creating table problem

wxdqz

New Member
I'm a mysql database newbies.I have encountered a problem when creating table.For example: I want to create a post table like that:create table post ( ID int(5) default '0' NOT NULL auto_increment, TopicID int(5) default '0' NOT NULL, ..... ..... Primary key(ID));My problem is after executing "desc post" within mysql> prompt"Default" field show NULL but I declared it as 0 before.So would anyone tell me what's the problem about this?Thx
 
Back
Top