Re: [PHP] Help needed with mysql import

2011-03-02 Thread Alex
You shouldn't have a default value in an auto increment field. You can set AUTO_INCREMENT to 0 and start with 1, but as auto increment is a unique field and its automagically incremented, you should not set a default value on it... -- Sent from my Android phone with K-9 Mail. Please excuse my

Re: [PHP] Help needed with mysql import

2011-03-02 Thread Jim Lucas
On 3/2/2011 4:25 AM, Alex wrote: You shouldn't have a default value in an auto increment field. You can set AUTO_INCREMENT to 0 and start with 1, but as auto increment is a unique field and its automagically incremented, you should not set a default value on it... This is fine and dandy

Re: [PHP] Help needed with mysql import

2011-03-02 Thread Jim Lucas
On 3/2/2011 9:48 AM, Ashley Sheridan wrote: Jim Lucas li...@cmsws.com wrote: On 3/2/2011 4:25 AM, Alex wrote: You shouldn't have a default value in an auto increment field. You can set AUTO_INCREMENT to 0 and start with 1, but as auto increment is a unique field and its automagically

Fwd: [PHP] Help needed with mysql import

2011-03-02 Thread Ashim Kapoor
-- Forwarded message -- From: Ashim Kapoor ashimkap...@gmail.com Date: Thu, Mar 3, 2011 at 7:22 AM Subject: Re: [PHP] Help needed with mysql import To: Jim Lucas li...@cmsws.com CREATE TABLE IF NOT EXISTS `ajax_products` ( `id` int(11) NOT NULL auto_increment, `name` varchar

[PHP] Help needed with mysql import

2011-03-01 Thread Ashim Kapoor
Dear all, I am trying to make a website with php and I found the following code in a book and I am trying to import it. The following are the beginning of the file i am trying to import with the command mysql -u root -pmypassword certainty dump I get the following error : ERROR 1067 (42000) at

Re: [PHP] Help needed with mysql import

2011-03-01 Thread Thijs Lensselink
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/02/2011 07:56 AM, Ashim Kapoor wrote: Dear all, I am trying to make a website with php and I found the following code in a book and I am trying to import it. The following are the beginning of the file i am trying to import with the