Re: [[PHP-DB] How to autoincrement an autoincrementing field (MySQL)?]

Insert with a value of zero (0) or don't specify the column at all (uses the default increment). Hope this helps, Ron Patterson USA.NET Alan Hale <adhale@bryos.co.uk> wrote: > 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 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1