这是原来的文件,导入就出问题了/*
SQLyog v10.2
MySQL - 5.6.25 : Database - toyou
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`toyou` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */;USE `toyou`;/*Table structure for table `book` */CREATE TABLE `book` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_croatian_ci DEFAULT NULL,
`bookid` int(20) NOT NULL,
`author` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`press` varchar(50) COLLATE utf8_croatian_ci DEFAULT NULL,
`state` varchar(11) COLLATE utf8_croatian_ci DEFAULT NULL,
`time` date DEFAULT NULL,
`price` double(20,0) DEFAULT NULL,
`total` int(20) DEFAULT NULL,
`category` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`re` varchar(200) COLLATE utf8_croatian_ci DEFAULT NULL,
PRIMARY KEY (`id`,`bookid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;/*Data for the table `book` */insert into `book`(`id`,`name`,`bookid`,`author`,`press`,`state`,`time`,`price`,`total`,`category`,`re`) values (4,'qw',123,'qw','qw','','2016-11-17',123,12,'科学','123123');/*Table structure for table `person` */
CREATE TABLE `person` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`brrowbookid` int(20) NOT NULL,
`name` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`password` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`sex` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`identification` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`tel` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`res` varchar(200) COLLATE utf8_croatian_ci DEFAULT NULL,
`idennum` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
`type` varchar(20) COLLATE utf8_croatian_ci DEFAULT NULL,
PRIMARY KEY (`id`,`brrowbookid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;/*Data for the table `person` */insert into `person`(`id`,`brrowbookid`,`name`,`password`,`sex`,`identification`,`tel`,`res`,`idennum`,`type`) values (1,123,'zm','123',NULL,NULL,NULL,NULL,NULL,'admin');/*Table structure for table `personbook` */
CREATE TABLE `personbook` (
`id` int(20) NOT NULL,
`pid` int(20) DEFAULT NULL,
`bid` int(20) DEFAULT NULL,
`res` int(200) DEFAULT NULL,
`brrowtime` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_croatian_ci;/*Data for the table `personbook` *//*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
你看一下 sqlyog的错误日志,到底是什么原因导致在执行时报错的