How to autoincrement an autoincrementing field (MySQL)?
| From: | Alan Hale | Date: | Wed, 02 May 2001 17:29:30 +0000 |
| Subject: | How to autoincrement an autoincrementing field (MySQL)? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9060@lists.php.net to get a copy of this message | ||
OK, I give up - I can't find out how to do this. I thought I'd tracked
it down in my copy of O'Reilly's 2MySQL and mSQL which says that you put
NULL as the value for an autoincrementing, NOT NULL field in an INSERT
statement:
e.g. INSERT INTO records (record_id, name, etc.....) VALUES (NULL,
'Alan', etc.)
which is wierd enough. But it doesn't work (not via PHP mysql_query()
anyhow) - predictably, I get an error 1048 Column 'record_id' cannot be
null.
Help please!
TIA
Alan Hale