RE: [PHP] mysql problem

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:josh@gfunk007.com] > 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" <josh@gfunk007.com> > To: "PHP User Group" <php-general@lists.php.net> > 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" <huntsman@hermes.nisu.flinders.edu.au> > > To: "Josh G" <josh@gfunk007.com>; "PHP User Group" > > <php-general@lists.php.net> > > 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: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >