On Saturday 08 September 2001 00:10, Mysql List wrote:
> Thanks,
>
> I already tried that, and I am only trying to insert about a dozen fields.
>
> Thanks for the response, I will wait and see if anyone else has an idea.
The documentation:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
has the answer (but not very clearly).
The AUTO_INCREMENT parameter is set on a per-table and not a per-row basis,
so the definition comes after the row definitions, e.g.:
CREATE TABLE mytable(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY)
AUTO_INCREMENT=1000;
HTH
Ian Barwick
> > Maybe....I guess....There's either too many datatypes or try putting like
> > this (again, probably wont work)
> >
> > Auto_Increment=1000, .....
> >
> > - Deryck H
> > - http://www.comp-u-exchange.com
> > ----- Original Message -----
> > From: "Mysql List" <[EMAIL PROTECTED]>
> > To: "Deryck Henson" <[EMAIL PROTECTED]>
> > Cc: "mysql" <[EMAIL PROTECTED]>
> > Sent: Friday, September 07, 2001 4:26 PM
> > Subject: Re: Question
> >
> > > That didn't work either.
> > > The documentation seems to show that you have to use = 1000, but I
>
> can't
>
> > > get it to work.
> > >
> > > > Try putting it like this ::
> > > >
> > > > AUTO_INCREMENT(1000), .....
> > > >
> > > > Not sure but that should work
> > > >
> > > > - Deryck H
> > > > - http://www.comp-u-exchange.com
> > > > ----- Original Message -----
> > > > From: "Mysql List" <[EMAIL PROTECTED]>
> > > > To: "mysql" <[EMAIL PROTECTED]>
> > > > Sent: Friday, September 07, 2001 3:49 PM
> > > > Subject: Question
> > > >
> > > > > Hi,
> > > > > Why is mysql(ver 3.23.41) complaining about this:
> > > > >
> > > > > CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY
>
> KEY
>
> > > > (ID),
> > > >
> > > > > I know it is not the entire statement, but mysql does not like the
> > > > > AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
> > > > >
> > > > > Thanks,
> > > > > Chris
> >
> > ---------------------------------------------------------------------
> >
> > > > > Before posting, please check:
> > > > > http://www.mysql.com/manual.php (the manual)
> > > > > http://lists.mysql.com/ (the list archive)
> > > > >
> > > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > > To unsubscribe, e-mail
> > > >
> > > > <[EMAIL PROTECTED]>
> > > >
> > > > > Trouble unsubscribing? Try:
>
> http://lists.mysql.com/php/unsubscribe.php
>
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> >
> > <[EMAIL PROTECTED]>
> >
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
>
> <[EMAIL PROTECTED]>
>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Ian Barwick - Developer [EMAIL PROTECTED]
http://www.akademie.de
"Luncheon meat tables with MySQL data"
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
