ZugnffsverletZung bei Address 055A38DF inModul'MySOL-Frontt.exe' Leson von Adress 00000008
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '事物，实际上都有其理性的根源....',25,16.8,'images/book1.jpg',320 (1064) - 事物，实际上都有其理性的根源....',25,16.8,'images/book1.jpg',320,'文学出版社','布鲁斯','2010-01-20 12:10:19',1,1,0,0,120); INSERT INTO `tb_book` VALUES (2,1,1,'我们的杜拉拉2','200907047','《我们的杜拉拉》收录了李可独家访谈，柳传志、徐静蕾、姚晨、赵赵、郎平以及千万读者感动热评，杜拉拉经典语录....',36,22.4,'images/book5.jpg',230,'新华出版社','爱死布鲁斯','2010-01-20 12:10:19',0,1,0,1,120); INSERT INTO `tb_book` VALUES (3,1,1,'佐藤可士和的超整理术2','200907048','《佐藤可士和的超整理术》：如果说原研哉奠定了无印良品的设计哲学的话,那佐藤可士和就创造了UNIQLO优衣库的视觉精神,而现在UNIQLO已经成为了一个新的日本设计象征....',56,49.8,'images/book3.jpg',412,'新华出版社','桑德勒','2010-01-20 12:10:19',0,1,1,1,120); INSERT INTO `tb_book` VALUES (4,1,1,'EnglishBook2','200907049','This is the Asian adaptation of N. Gregory Mankiw s et leading textbook Principles of Economics. While maintaining all the strengths of the original book, Professor Euston Quah and Dr. Peter Wilson have provided materials and examples that are most relevant to students in Asia.',39,37.4,'images/book9.jpg',502,'新华出版社','希特勒桑德勒','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (5,1,1,'晚间西红柿减肥','9787531723950','本书是日本销量第一的美容减肥畅销书，上市3个月狂卖85万册。本书作者，“日本第一的西红柿博士”——唐泽明告诉大家，西红柿减肥好吃、轻松、易瘦、健康、美肤，在3个月内减掉11斤并且使肌肤回到21岁时的状态。不管大家是否爱吃西红柿，晚间西红柿减肥都能持续下去，因为晚间西红柿有如下秘诀：清清爽爽的血液、滑溜溜的肌肤、美美地吃、舒舒服服、瘦！来自西红柿的美丽瘦身+美肤过程，你一定要亲身体验一番哦',22,11.6,'images/1.jpg',128,'北方文艺出版社','（日）唐泽明 著，周晓晗 译','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (6,1,1,'晚间西红柿','9787531723987','本书是日本销量第一的美容减肥畅销书，上市3个月狂卖85万册。本书作者，“日本第一的西红柿博士”——唐泽明告诉大家，西红柿减肥好吃、轻松、易瘦、健康、美肤，在3个月内减掉11斤并且使肌肤回到21岁时的状态。不管大家是否爱吃西红柿，晚间西红柿减肥都能持续下去，因为晚间西红柿有如下秘诀：清清爽爽的血液、滑溜溜的肌肤、美美地吃、舒舒服服、瘦！来自西红柿的美丽瘦身+美肤过程，你一定要亲身体验一番哦',54,46.6,'images/7.jpg',128,'北方文艺出版社','（日）唐泽明 著，周晓晗 译','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (7,1,1,'西红柿','97875317239657','本书是日本销量第一的美容减肥畅销书，上市3个月狂卖85万册。本书作者，“日本第一的西红柿博士”——唐泽明告诉大家，西红柿减肥好吃、轻松、易瘦、健康、美肤，在3个月内减掉11斤并且使肌肤回到21岁时的状态。不管大家是否爱吃西红柿，晚间西红柿减肥都能持续下去，因为晚间西红柿有如下秘诀：清清爽爽的血液、滑溜溜的肌肤、美美地吃、舒舒服服、瘦！来自西红柿的美丽瘦身+美肤过程，你一定要亲身体验一番哦',34,26.6,'images/8.jpg',128,'北方文艺出版社','（日）唐泽明 著，周晓晗 译','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (8,1,1,'西红柿平','978753176657','本书是日本销量第一的美容减肥畅销书，上市3个月狂卖85万册。本书作者，“日本第一的西红柿博士”——唐泽明告诉大家，西红柿减肥好吃、轻松、易瘦、健康、美肤，在3个月内减掉11斤并且使肌肤回到21岁时的状态。不管大家是否爱吃西红柿，晚间西红柿减肥都能持续下去，因为晚间西红柿有如下秘诀：清清爽爽的血液、滑溜溜的肌肤、美美地吃、舒舒服服、瘦！来自西红柿的美丽瘦身+美肤过程，你一定要亲身体验一番哦',44,36.6,'images/9.jpg',128,'北方文艺出版社','（日）唐泽明 著，周晓晗 译','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (9,1,1,'郎咸平说','9787531723951','在本书中，郎咸平教授谈兴甚浓，兴致盎然，语言大胆诙谐，而且看问题一针见血，直达事件最真实层面。从3.14事件中CNN对中国的诋毁、到汶川大地震的众志成城；从大众对奥运经济的过度期盼到奥运礼仪的中华风采；还有海峡两岸对台湾现状的真实解读，功夫熊猫凸显的文化融合以及诸葛亮能否成为优秀的企业家；郎教授都做了最真切的解读，全部都是在电视、平面媒体上闻所未闻的观点，这是在郎教授对东西两种文化体系透彻理解的基础上并且从社会民众中的普遍的小细节中展示出大事件的根本趋势',25,13.6,'images/2.jpg',128,'北方文艺出版社','郎咸平','2010-01-20 12:10:19',1,1,1,1,120); INSERT INTO `tb_book` VALUES (10,1,1,'郎咸平说234','97875317239511','在本书中，郎咸平教授谈兴甚浓，兴致21 16:52:19',1); INSERT INTO `tb_order` VALUES (2,'sanqing','三清','北京市海淀区','123456','[email protected]','2010-01-22 09:33:25',0); /*!40000 ALTER TABLE `tb_order` ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table tb_orderitem # DROP TABLE IF EXISTS `tb_orderitem`; CREATE TABLE `tb_orderitem` ( `orderItemId` int(11) NOT NULL AUTO_INCREMENT, `orderId` int(11) DEFAULT NULL, `bookId` int(11) DEFAULT NULL, `bookName` varchar(50) DEFAULT NULL, `price` float DEFAULT NULL, `bookNum` int(11) DEFAULT NULL, PRIMARY KEY (`orderItemId`), KEY `orderId` (`orderId`), KEY `bookId` (`bookId`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; INSERT INTO `tb_orderitem` VALUES (1,1,6,'晚间西红柿',46.6,1); INSERT INTO `tb_orderitem` VALUES (2,2,2,'我们的杜拉拉2',22.4,1); /*!40000 ALTER TABLE `tb_orderitem` ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table tb_subtype # DROP TABLE IF EXISTS `tb_subtype`; CREATE TABLE `tb_subtype` ( `subTypeId` int(11) NOT NULL AUTO_INCREMENT, `superTypeId` int(11) DEFAULT NULL, `subTypeName` varchar(50) DEFAULT NULL, PRIMARY KEY (`subTypeId`), KEY `superTypeId` (`superTypeId`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gbk; INSERT INTO `tb_subtype` VALUES (1,1,'程序设计'); INSERT INTO `tb_subtype` VALUES (2,1,'网络技术'); INSERT INTO `tb_subtype` VALUES (3,1,'计算机基础'); INSERT INTO `tb_subtype` VALUES (4,2,'中国文学'); INSERT INTO `tb_subtype` VALUES (5,2,'外国文学'); INSERT INTO `tb_subtype` VALUES (6,3,'油画'); INSERT INTO `tb_subtype` VALUES (7,3,'水彩'); INSERT INTO `tb_subtype` VALUES (8,3,'雕刻'); /*!40000 ALTER TABLE `tb_subtype` ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table tb_supertype # DROP TABLE IF EXISTS `tb_supertype`; CREATE TABLE `tb_supertype` ( `superTypeId` int(11) NOT NULL AUTO_INCREMENT, `typeName` varchar(50) DEFAULT NULL, PRIMARY KEY (`superTypeId`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=gbk; INSERT INTO `tb_supertype` VALUES (1,'IT技术'); INSERT INTO `tb_supertype` VALUES (2,'文学'); INSERT INTO `tb_supertype` VALUES (3,'艺术'); INSERT INTO `tb_supertype` VALUES (28,'科技'); /*!40000 ALTER TABLE `tb_supertype` ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table tb_user # DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `password` varchar(16) NOT NULL, `email` varchar(50) NOT NULL, `trueName` varchar(40) NOT NULL, `sex` varchar(30) DEFAULT NULL, `birthday` varchar(20) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `postcode` varchar(10) DEFAULT NULL, `phone` varchar(15) DEFAULT NULL, `mphone` varchar(15) DEFAULT NULL, `question` varchar(30) NOT NULL, `answer` varchar(30) NOT NULL, `img` varchar(100) DEFAULT NULL, `score` int(11) DEFAULT '1000', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk; INSERT INTO `tb_user` VALUES (1,'sanqing','sanqing','[email protected]','sanqing','男','1980-01-01','abc',NULL,'010-01010101','13123456789','你最爱的人的名字叫什么','123',NULL,NULL); /*!40000 ALTER TABLE `tb_user` ENABLE KEYS */; UNLOCK TABLES; # # Foreign keys for table tb_book # ALTER TABLE `tb_book` ADD CONSTRAINT `tb_book_ibfk_1` FOREIGN KEY (`subTypeId`) REFERENCES `tb_subtype` (`subTypeId`), ADD CONSTRAINT `tb_book_ibfk_2` FOREIGN KEY (`superTypeId`) REFERENCES `tb_supertype` (`superTypeId`); # # Foreign keys for table tb_orderitem # ALTER TABLE `tb_orderitem` ADD CONSTRAINT `tb_orderitem_ibfk_1` FOREIGN KEY (`orderId`) REFERENCES `tb_order` (`orderId`), ADD CONSTRAINT `tb_orderitem_ibfk_2` FOREIGN KEY (`bookId`) REFERENCES `tb_book` (`bookId`); # # Foreign keys for table tb_subtype # ALTER TABLE `tb_subtype` ADD CONSTRAINT `tb_subtype_ibfk_1` FOREIGN KEY (`superTypeId`) REFERENCES `tb_supertype` (`superTypeId`); /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;_supertype` ( `superTypeId` int(11) NOT NULL AUTO_INCREMENT, `typeName` varchar(50) DEFAULT NULL, PRIMARY KEY (`superTypeId`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=gbk; INSERT INTO `tb_supertype` VALUES (1,'IT技术'); INSERT INTO `tb_supertype` VALUES (2,'文学'); INSERT INTO `tb_supertype` VALUES (3,'艺术'); INSERT INTO `tb_supertype` VALUES (28,'科技'); /*!40000 ALTER TABLE `tb_supertype` ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table tb_user # DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `password` varchar(16) NOT NULL, `email` varchar(50) NOT NULL, `trueName` varchar(40) NOT NULL, `sex` varchar(30) DEFAULT NULL, `birthday` varchar(20) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `postcode` varchar(10) DEFAULT NULL, `phone` varchar(15) DEFAULT NULL, `mphone` varchar(15) DEFAULT NULL, `question` varchar(30) NOT NULL, `answer` varchar(30) NOT NULL, `img` varchar(100) DEFAULT NULL, `score` int(11) DEFAULT '1000', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk; INSERT INTO `tb_user` VALUES (1,'sanqing','sanqing','[email protected]','sanqing','男','1980-01-01','abc',NULL,'010-01010101','13123456789','你最爱的人的名字叫什么','123',NULL,NULL); /*!40000 ALTER TABLE `tb_user` ENABLE KEYS */; UNLOCK TABLES; # # Foreign keys for table tb_book # ALTER TABLE `tb_book` ADD CONSTRAINT `tb_book_ibfk_1` FOREIGN KEY (`subTypeId`) REFERENCES `tb_subtype` (`subTypeId`), ADD CONSTRAINT `tb_book_ibfk_2` FOREIGN KEY (`superTypeId`) REFERENCES `tb_supertype` (`superTypeId`); # # Foreign keys for table tb_orderitem # ALTER TABLE `tb_orderitem` ADD CONSTRAINT `tb_orderitem_ibfk_1` FOREIGN KEY (`orderId`) REFERENCES `tb_order` (`orderId`), ADD CONSTRAINT `tb_orderitem_ibfk_2` FOREIGN KEY (`bookId`) REFERENCES `tb_book` (`bookId`); # # Foreign keys for table tb_subtype # ALTER TABLE `tb_subtype` ADD CONSTRAINT `tb_subtype_ibfk_1` FOREIGN KEY (`superTypeId`) REFERENCES `tb_supertype` (`superTypeId`); /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;=@OLD_SQL_MODE */;
Menu: Extras / SynchronizeMySQL-Front allows the synchronization of different tables. The primary index is used to identify the data. This means that tables can be synchronized only with a primary index. The objects of the table(s) (fields / indices) are identified with the column names. Foreign keys are not transferred during the synchronization.You can synchronizie two different tables on different (or the same) session.Otherwise it's possible to synchronize two databases or two entiered sessions. But it's not recommended to synchronize two sessions, since this encloses the "mysql" database.What:Either the data structure (objects) and/or the data can be synchronized. Direction:Only the table(s) identified as slaves are modified. Update existing objects:The settings (e.g. data type) of existing object is updated.Existing data:Existing data are updated (overwritten) without any warning.Ignore Foreign Keys:Foreign keys are deactivated during synchronization. Please consult the MySQL manual for a description of advantages and disadvantages of this functionality. Lock Tables:A table being synchronized is locked to other users / programs during the synchronization process. Please consult the MySQL manual for a description of advantages and disadvantages of this functionality. Backup:A table can be generated before synchronizing data. This table will be assigned the name of the respective table with the extension "_bak". Already existing copies with this extension are overwritten without warning. A backup copy is generated completely within the database. Creating backups can use significant resources of the database if tables are large. Warning:Existing data are changed during synchronization and cannot be restored.User or program errors are always a possibility.Data backups are therefore important and should be created frequently!
2:用记事本打开.SQL，复制
3：粘贴到MYSQL-FRONT
直接双击打开，安装SQL-Front的时候会默认的将.sql的扩展名默认使用SQL-Front打开。