CREATE TABLE Mike01table01 ( user_name varchar(10) NOT NULL default '', password varchar(10) NOT NULL default '', email varchar(50) NOT NULL default '', name varchar(50) NOT NULL default '', sex varchar(6) NOT NULL default '', PRIMARY KEY (user_name) ) TYPE=MyISAM;