ahhh... yes... :)
the linux version is much stricter when it comes
to table definitions...
i had the same problem trying to declare an INDEX
for my table too.... for linux, any key that
you use as an INDEX on a table must be declared
NOT NULL (whereas the win32 port doesnt seem
to care very much)...
for future reference, i reccomend trying out your
SQL code in the MySQL monitor (the command line
utility that comes with the server)... generally
the error messages are *MUCH* more helpful
than the ones i get via PHP
> -----Original Message-----
> From: Josh G [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 17:00
> To: PHP User Group
> Subject: Re: [PHP] mysql problem
>
>
> Ok, I've fixed the problem, it seems there's some major differences
> between the linux / win32 ports of the client.
>
> instead of
>
> blah integer primary key auto_increment
>
> which works on windows, I used
>
> blah integer not null auto_increment primary key
>
> and now it works... I love computers, I really do.
>
> Gfunk - http://www.gfunk007.com/
>
> I sense much beer in you. Beer leads to intoxication, intoxication to
> hangovers, and hangovers to... suffering.
>
>
> ----- Original Message -----
> From: "Josh G" <[EMAIL PROTECTED]>
> To: "PHP User Group" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 20, 2001 11:42 AM
> Subject: Re: [PHP] mysql problem
>
>
> > Nope, I've been using autoincrement on that box for a year or so.
> >
> > It's not a copy/paste thing, cause I'm getting it when I type the lines
> > in by hand, too...
> >
> > Gfunk - http://www.gfunk007.com/
> >
> > I sense much beer in you. Beer leads to intoxication, intoxication to
> > hangovers, and hangovers to... suffering.
> >
> >
> > ----- Original Message -----
> > From: "David Robley" <[EMAIL PROTECTED]>
> > To: "Josh G" <[EMAIL PROTECTED]>; "PHP User Group"
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 20, 2001 11:41 AM
> > Subject: Re: [PHP] mysql problem
> >
> >
> > > On Tue, 20 Feb 2001 10:57, Josh G wrote:
> > > > Hi, sorry to post this here, but it's driving me crazy. On my local
> > > > machine, the following works no furys:
> > > >
> > > > create table category (category_id integer primary key
> > > > auto_increment,name varchar(255) );
> > > >
> > > > But on the production machine, I get:
> > > >
> > > > ERROR 1064: parse error near 'auto_increment,name varchar(255) )' at
> > > > line 1
> > > >
> > > > Any idea why???? It's driving me nuts......
> > > >
> > > > Gfunk - http://www.gfunk007.com/
> > > >
> > >
> > > Is the version of Mysql on the production box an older one?
> autoincrement
> > > is comparatively new, I think.
> > >
> > > --
> > > David Robley | WEBMASTER & Mail List Admin
> > > RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
> > > AusEinet | http://auseinet.flinders.edu.au/
> > > Flinders University, ADELAIDE, SOUTH AUSTRALIA
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]