Re: MYSQL 5 auto increment not working
| From: | Bruno Fajardo | Date: | Thu, 21 May 2009 13:13:38 +0000 |
| Subject: | Re: MYSQL 5 auto increment not working | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-292863@lists.php.net to get a copy of this message | ||
2009/5/21 Leidago !Noabeb <leidago@googlemail.com>
> Hi All
>
>
> I know this is not strictly a PHP question, but i have a problem whenever i
> insert a record using PHP. Basically the auto increment field does not work
> at all. Here's the structure of the table that i'm using:
>
> CREATE TABLE
children (
> cid int(4) NOT NULL auto_increment,
> cname char(50) default NULL,
> csname char(50) default NULL,
> PRIMARY KEY (cid)
> ) ENGINE=InnoDB
>
> I use PHP 5.1 and MYSQL 5
>
> I'm pretty sure the code i use to insert the data is sound since i've
> tested
> it with older versions of MYSQL.
>
> Has anyone else had similar problems?
Did you left empty the field cid (PK) in your INSERT statement?