DROP TABLE IF EXISTS grade;
CREATE TABLE grade (
Name varchar(30) NOT NULL default '',
note char(3) NOT NULL default '',
ID tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;--
-- Dumping data for table 'grade'
--INSERT INTO grade VALUES ('初一','c1',2);
INSERT INTO grade VALUES ('初二','c2',3);
INSERT INTO grade VALUES ('初三','c3',4);
INSERT INTO grade VALUES ('初中','c',1);
INSERT INTO grade VALUES ('高一','g1',6);
INSERT INTO grade VALUES ('高二','g2',7);
INSERT INTO grade VALUES ('高中','g',5);
INSERT INTO grade VALUES ('高三理科','g3l',9);
INSERT INTO grade VALUES ('高三文科','g3w',10);
-----------------------------
错误信息:
ERROR1406 data too long for column 'Name' at row 1;Mysql 5.0,数据库为 UTF-8字符,换成GKB2312也是一样的!
CREATE TABLE grade (
Name varchar(30) NOT NULL default '',
note char(3) NOT NULL default '',
ID tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;--
-- Dumping data for table 'grade'
--INSERT INTO grade VALUES ('初一','c1',2);
INSERT INTO grade VALUES ('初二','c2',3);
INSERT INTO grade VALUES ('初三','c3',4);
INSERT INTO grade VALUES ('初中','c',1);
INSERT INTO grade VALUES ('高一','g1',6);
INSERT INTO grade VALUES ('高二','g2',7);
INSERT INTO grade VALUES ('高中','g',5);
INSERT INTO grade VALUES ('高三理科','g3l',9);
INSERT INTO grade VALUES ('高三文科','g3w',10);
-----------------------------
错误信息:
ERROR1406 data too long for column 'Name' at row 1;Mysql 5.0,数据库为 UTF-8字符,换成GKB2312也是一样的!
CREATE TABLE grade (
Name varchar(30) NOT NULL default '',
note char(3) NOT NULL default '',
ID tinyint(4) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;--
-- Dumping data for table 'grade'
--INSERT INTO grade VALUES ('初一','c1',2);
INSERT INTO grade VALUES ('初二','c2',3);
INSERT INTO grade VALUES ('初三','c3',4);
INSERT INTO grade VALUES ('初中','c',1);
INSERT INTO grade VALUES ('高一','g1',6);
INSERT INTO grade VALUES ('高二','g2',7);
INSERT INTO grade VALUES ('高中','g',5);
INSERT INTO grade VALUES ('高三理科','g3l',9);
INSERT INTO grade VALUES ('高三文科','g3w',10);