MySQL Forums
Re: 1067 - Invalid default value for 'nr'
Posted by: Sarah Sproehnle ()
Date: May 31, 2006 09:34PM
Roy,
In order to use AUTO_INCREMENT, the column must be indexed and cannot have a default value.
Sarah Sproehnle
MySQL AB
www.mysql.com
In order to use AUTO_INCREMENT, the column must be indexed and cannot have a default value.
Sarah Sproehnle
MySQL AB
www.mysql.com
| Subject | Views | Written By | Posted |
|---|---|---|---|
| 1067 - Invalid default value for 'nr' | 4102 | Roy Kisembo | 04/24/2006 03:13PM |
| Re: 1067 - Invalid default value for 'nr' | 2185 | Sarah Sproehnle | 05/31/2006 09:34PM |
Sorry, you can't reply to this topic. It has been closed.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.