create table 'person'(
'ID' INT(11) NOT NULL auto_increment,
'Name' VARCHAR(20) not null 'DEFAULT',
'sex' CHAR(1) default NULL,
'Address' VARCHAR(200) default NULL,
PRIMARY KEY ('ID'),
) TYPE=MYISAM;
'ID' INT(11) NOT NULL auto_increment,
'Name' VARCHAR(20) not null 'DEFAULT',
'sex' CHAR(1) default NULL,
'Address' VARCHAR(200) default NULL,
PRIMARY KEY ('ID'),
) TYPE=MYISAM;
'ID' INT PRIMARY KEY auto_increment,
'Name' VARCHAR(20) not null ,
'sex' CHAR(1) default NULL,
'Address' VARCHAR(200) default '' Y
) TYPE=MYISAM;
lz可以这样试试,我这所liunx下,不好编辑!
2. `Name` VARCHAR(20) not null default 'DEFAULT',
3. TPRIMARY KEY ('ID'),, 逗号去掉。
4. TYPE=MYISAM; 换成 ENGINE=MYISAM; (5.1以后以engine 代替type, 但不是必需的)mysql> create table `person`(
-> `ID` INT(11) NOT NULL auto_increment,
-> `Name` VARCHAR(20) not null default 'DEFAULT',
-> `sex` CHAR(1) default NULL,
-> `Address` VARCHAR(200) default NULL,
-> PRIMARY KEY (`ID`)
-> ) ENGINE=MYISAM;
Query OK, 0 rows affected (0.11 sec)
5.1以上
create table `person`(
`ID` INT(11) NOT NULL auto_increment,
`Name` VARCHAR(20) not null default 'DEFAULT',
`sex` CHAR(1) default NULL,
`Address` VARCHAR(200) default NULL,
PRIMARY KEY (`ID`) ) ENGINE=MYISAM;
mysql> create table `person`(
-> `ID` INT(11) NOT NULL auto_increment,
-> `Name` VARCHAR(20) not null default 'DEFAULT',
-> `sex` CHAR(1) default NULL,
-> `Address` VARCHAR(200) default NULL,
-> PRIMARY KEY (`ID`)
-> ) ENGINE=MYISAM;
Query OK, 0 rows affected (0.11 sec)
ID INTEGER(11) NOT NULL auto_increment,
Name VARCHAR(20) not NULL,
sex CHAR(1) default NULL,
Address VARCHAR(200) default NULL,
PRIMARY KEY (ID)
) TYPE=MYISAM;把引号全部去掉