On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote: > Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a > problem with the new release. > I have this table... > > provasql > CREATE TABLE `provasql` > > `idrow` bigint(20) unsigned NOT NULL default '0', > `descr` varchar(50) default NULL, > PRIMARY KEY (`idrow`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > > > ...this is the SQL command... > > insert into provasql ( idrow, descr ) > select ( select max(c.idrow)+1 from provasql c ) , 'This is only a test'; > > > ...and this is the error: > > ERROR 1263 (22004): Column set to default value; NULL supplied to NOT NULL > colum > n 'idrow' at row 1 > > > With MySQL 4.1.11 I'd never get this error message, but it happens with the > 5.0.15 version. > Can anyone help me?
Mysql 5 is much more picky on things you shouldnt have been able to do in the first place.. Just change idrow to auto_increment and stop doing max.. Its not needed. innodb properly handles auto_increment now. Jeff
pgpApFheY1YGC.pgp
Description: PGP signature
