Re: MYSQL 5 auto increment not working
| From: | Per Jessen | Date: | Thu, 21 May 2009 13:31:22 +0000 |
| Subject: | Re: MYSQL 5 auto increment not working | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-292865@lists.php.net to get a copy of this message | ||
Leidago !Noabeb wrote:
> 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've just tried creating that table and doing a few inserts - works just
fine here - mysql 5.0.26.
/Per
--
Per Jessen, Zürich (26.7°C)