Re: hi

[Stefan Hinz]

You can avoid error 1067 by assigning valid default values to your columns. Look at this example:

mysql> create table tbl_a (i int default 'abcde');
ERROR 1067 (42000): Invalid default value for 'i'
Warning (Code 1366): Incorrect integer value: 'abcde' for column 'i' at row 1
Error (Code 1067): Invalid default value for 'i'

'abcde' isn't a valid value for integer columns, so when trying to assign that string as a default value you get an error. This is explained here:

http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html

Stefan Hinz, MySQL Documentation, Berlin, Germany