1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE `books` ( `code` CHAR(11) NOT NULL PRIMARY KEY, `name` CHAR(250) NOT NULL, `author` CHAR(250), `publisher` CHAR(250) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `books` VALUES ('01','JavaScript高级程序设计','司徒1','北京邮电出版社1'); INSERT INTO `books` VALUES ('02','你不知道的JavaScript','司徒2','北京邮电出版社2'); INSERT INTO `books` VALUES ('03','JavaScript设计模式与开发实践','司徒3','北京邮电出版社3'); INSERT INTO `books` VALUES ('04','CSS揭秘','司徒4','北京邮电出版社4'); INSERT INTO `books` VALUES ('05','CSS世界','司徒5','北京邮电出版社5'); INSERT INTO `books` VALUES ('06','WebKit技术内幕','司徒6','北京邮电出版社6'); INSERT INTO `books` VALUES ('07','Node.js:来一打 C++ 扩展','司徒7','北京邮电出版社7'); INSERT INTO `books` VALUES ('08','深入浅出Node.js','司徒8','北京邮电出版社8'); INSERT INTO `books` VALUES ('09','HTML5 Canvas核心技术图形动画与游戏开发','司徒9','北京邮电出版社9');
|