Mysql warning - why?

[likwid]

create table nubs (name varchar(30) primary key, des text not null ) type = innodb;

Query OK, 0 rows affected, 1 warning (0.00 sec)

Why do i receive this warning when creating this table? Is there some way I can view mysql warnings?

TIA

 

[Ladforce]

text data type cannot be given a default value

 

[likwid]

Ah cheers. How can I remedy this?

 

[Ladforce]

Sorry you haddent given it a default value - I read it too fast you need to use engine=innodb to get rid of the warning. To see warnings use 'show warnings;'

 

[likwid]

aaaaaaah

cheers !!!