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');
   |