Fwd: [PHP] Help needed with mysql import

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

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" 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 inc

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 u

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 br

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 co

[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