Hi,

Is it possible when creating a table to have the auto incremenet field
start at, for example, 1000 instead of 1. I would like to have a table
called orders and want to use this number as an invoice code. Cheers

Burnsy

bissatch@yahoo.co.uk wrote:
> Hi,
>
> Is it possible when creating a table to have the auto incremenet field
> start at, for example, 1000 instead of 1. I would like to have a table
> called orders and want to use this number as an invoice code. Cheers
>
> Burnsy

Try this little trick.
Take (most of) the subject of your post:

Auto incremenet primary key field starting at

Type them into the search box at www.google.com
Then click the "I'm Feeling Lucky" button
Then read the article.

Even though you spelling of "increment" is hopelessly incorrect, it still
takes you straight to the correct page of the manual!

On Wed, 30 Jan 2008 08:27:19 -0800 (PST),
bissatch@yahoo.co.uk wrote:

>Hi,
>
>Is it possible when creating a table to have the auto incremenet field
>start at, for example, 1000 instead of 1. I would like to have a table
>called orders and want to use this number as an invoice code. Cheers
>
>Burnsy

http://dev.mysql.com/doc/refman/5.0/...ate-table.html
in the paragraph "table_option:"
--
( Kees
)
c[_] As scarce as truth is, the supply has
always been in excess of demand. (#351)

On 30 Jan, 18:27, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> bissa...@yahoo.co.uk wrote:
> > Hi,
>
> > Is it possible when creating a table to have the auto incremenet field
> > start at, for example, 1000 instead of 1. I would like to have a table
> > called orders and want to use this number as an invoice code. Cheers
>
> > Burnsy
>
> Try this little trick.
> Take (most of) the subject of your post:
>
> Auto incremenet primary key field starting at
>
> Type them into the search box atwww.google.com
> Then click the "I'm Feeling Lucky" button
> Then read the article.
>
> Even though you spelling of "increment" is hopelessly incorrect, it still
> takes you straight to the correct page of the manual!

How witty of you, arent u the funny one today .. i accidentitialy
ineserted an extara character into increment so its 'hopelessly'
incorrect, what hope do i have in life :P

bissatch@yahoo.co.uk wrote:
> On 30 Jan, 18:27, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
>> bissa...@yahoo.co.uk wrote:
>> > Hi,
>>
>> > Is it possible when creating a table to have the auto incremenet
>> > field start at, for example, 1000 instead of 1. I would like to
>> > have a table called orders and want to use this number as an
>> > invoice code. Cheers
>>
>> > Burnsy
>>
>> Try this little trick.
>> Take (most of) the subject of your post:
>>
>> Auto incremenet primary key field starting at
>>
>> Type them into the search box atwww.google.com
>> Then click the "I'm Feeling Lucky" button
>> Then read the article.
>>
>> Even though you spelling of "increment" is hopelessly incorrect, it
>> still takes you straight to the correct page of the manual!
>
> How witty of you, arent u the funny one today .. i accidentitialy
> ineserted an extara character into increment so its 'hopelessly'
> incorrect, what hope do i have in life :P

You missed the point entirely. I wasn't criticising your spelling. I was
pointing out that even with the mis-spelled word, simply putting the subject
line INCLUDING THE MIS-SPELLED WORD into google, still went straight to the
correct page of the manual, by pressing the I'm Feeling Lucky button.

So before sticking your fucking tongue out at me, try examining why you are
so lazy that you couldn't be bothered to try to find the answer to your own
question first. Then consider how much more help you're likely to get here!