[Err] 1064 - 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 '/*
Navicat MySQL Data TransferSource Server : mysql
Source Serv' at line 1
[Err] /*
Navicat MySQL Data TransferSource Server : mysql
Source Server Version : 50534
Source Host : localhost:3306
Source Database : db_jiangzuoTarget Server Type : MYSQL
Target Server Version : 50534
File Encoding : 65001Date: 2016-02-09 17:39:05
*/SET FOREIGN_KEY_CHECKS=0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
没学过mysql只学了sqlsever,求救。。
Navicat MySQL Data TransferSource Server : mysql
Source Serv' at line 1
[Err] /*
Navicat MySQL Data TransferSource Server : mysql
Source Server Version : 50534
Source Host : localhost:3306
Source Database : db_jiangzuoTarget Server Type : MYSQL
Target Server Version : 50534
File Encoding : 65001Date: 2016-02-09 17:39:05
*/SET FOREIGN_KEY_CHECKS=0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
没学过mysql只学了sqlsever,求救。。
sql文件没有,看不了啊
Navicat MySQL Data TransferSource Server : mysql
Source Server Version : 50534
Source Host : localhost:3306
Source Database : db_jiangzuoTarget Server Type : MYSQL
Target Server Version : 50534
File Encoding : 65001Date: 2016-02-09 17:39:05
*/
就只有这一段声明,导入mysql后,老提示没有主键啊
/*
Navicat MySQL Data TransferSource Server : mysql
Source Server Version : 50534
Source Host : localhost:3306
Source Database : db_jiangzuoTarget Server Type : MYSQL
Target Server Version : 50534
File Encoding : 65001Date: 2016-02-09 17:39:05
*/SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `dtproperties`
-- ----------------------------
DROP TABLE IF EXISTS `dtproperties`;
CREATE TABLE `dtproperties` (
`id` int(11) DEFAULT NULL,
`objectid` int(11) DEFAULT NULL,
`property` varchar(64) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`uvalue` varchar(255) DEFAULT NULL,
`lvalue` longblob,
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of dtproperties
-- ------------------------------ ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`userId` int(11) DEFAULT NULL,
`userName` varchar(66) DEFAULT NULL,
`userPw` varchar(55) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'a', 'a');
INSERT INTO `t_admin` VALUES ('2', '', '');-- ----------------------------
-- Table structure for `t_doc`
-- ----------------------------
DROP TABLE IF EXISTS `t_doc`;
CREATE TABLE `t_doc` (
`id` int(11) DEFAULT NULL,
`mingcheng` varchar(66) DEFAULT NULL,
`fujian` varchar(50) DEFAULT NULL,
`fujianYuanshiming` varchar(55) DEFAULT NULL,
`shijian` varchar(50) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL,
`leixing` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_doc
-- ----------------------------
INSERT INTO `t_doc` VALUES ('6', '3333', '/upload/1449137336200.doc', '测试.doc', '2015-11-23', 'no', '教学大纲');
INSERT INTO `t_doc` VALUES ('7', '面向对象的特点教学大纲', '/upload/1449197814128.doc', '面向对象特点.doc', '2015-12-04', 'no', '教学大纲');-- ----------------------------
-- Table structure for `t_gonggao`
-- ----------------------------
DROP TABLE IF EXISTS `t_gonggao`;
CREATE TABLE `t_gonggao` (
`id` int(11) DEFAULT NULL,
`title` varchar(55) DEFAULT NULL,
`content` text,
`shijian` varchar(55) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_gonggao
-- ----------------------------
INSERT INTO `t_gonggao` VALUES ('1', '平台已开通', '平台已开通', '2016-1-13 22:51:57', null);
INSERT INTO `t_gonggao` VALUES ('2', '请大家使用讲座预订系统', '<p>请大家使用</p>', '2016-01-30', null);
INSERT INTO `t_gonggao` VALUES ('4', '爬虫讲座', '<div style=\"width: 720px; white-space: normal; word-spacing: 0px; text-transform: none; color: rgb(68,68,68); padding-bottom: 8px; padding-top: 0px; font: 14px/26px SimSun, \'Microsoft YaHei\', Arial, Helvetica, sans-serif; padding-left: 0px; margin: 0px; letter-spacing: normal; padding-right: 10px; background-color: rgb(255,255,255); text-indent: 2em; -webkit-text-stroke-width: 0px\">社会创新的话题并非是一个全新的话题,但对于社会创新的领域的实践需要持续的多方的支持才会真正落到实处,并真正为社会福祉发挥作用。Mark Anderson主任的讲座高屋建瓴又有积极的实践参考价值,为现场师生带来了深刻的启示。</div>\r\n<div style=\"width: 720px; white-space: normal; word-spacing: 0px; text-transform: none; color: rgb(68,68,68); padding-bottom: 8px; padding-top: 0px; font: 14px/26px SimSun, \'Microsoft YaHei\', Arial, Helvetica, sans-serif; padding-left: 0px; margin: 0px; letter-spacing: normal; padding-right: 10px; background-color: rgb(255,255,255); text-indent: 2em; -webkit-text-stroke-width: 0px\"> </div>\r\n<div class=\"img_center\" style=\"width: 720px; white-space: normal; word-spacing: 0px; text-transform: none; color: rgb(68,68,68); padding-bottom: 8px; text-align: center; padding-top: 0px; font: 14px/26px SimSun, \'Microsoft YaHei\', Arial, Helvetica, sans-serif; padding-left: 0px; clear: both; margin: 10px 0px; letter-spacing: normal; padding-right: 10px; background-color: rgb(255,255,255); text-indent: 0px; -webkit-text-stroke-width: 0px\"><img border=\"0\" alt=\"讲座现场\" src=\"http://news.jiangnan.edu.cn/images/content/2015-11/20151104140131839454.jpg\" style=\"max-width: 660px; border-top: rgb(204,204,204) 1px solid; border-right: rgb(204,204,204) 1px solid; border-bottom: rgb(204,204,204) 1px solid; padding-bottom: 3px; padding-top: 3px; padding-left: 3px; border-left: rgb(204,204,204) 1px solid; padding-right: 3px\" /><span style=\"width: 720px; text-align: center; margin-top: 10px; display: block\">讲座现场</span></div>', '2016-02-02', null);-- ----------------------------
-- Table structure for `t_keti`
-- ----------------------------
DROP TABLE IF EXISTS `t_keti`;
CREATE TABLE `t_keti` (
`keti_id` int(11) NOT NULL DEFAULT '0',
`keti_bianhao` varchar(50) DEFAULT NULL,
`keti_name` varchar(50) DEFAULT NULL,
`keti_jianjie` varchar(500) DEFAULT NULL,
`keti_zhuangtai` varchar(50) DEFAULT NULL,
`keti_zy` varchar(50) DEFAULT NULL,
`keti_ssxy` varchar(50) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL,
`tea_name` varchar(50) DEFAULT NULL,
`keti_skzc` varchar(50) DEFAULT NULL,
`keti_skjc` varchar(50) DEFAULT NULL,
`tea_id` int(11) DEFAULT NULL,
PRIMARY KEY (`keti_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_keti
-- ----------------------------
INSERT INTO `t_keti` VALUES ('13', '01001', '客户管理管理系统', 'jsp来做', '可预订', '学术会议', '信息科学与技术系', 'no', '李明', null, null, '1');
INSERT INTO `t_keti` VALUES ('14', '01002', 'jsp校园网', '用ssh框架', '可预订', '学术会议', '信息科学与技术系', 'no', '李明', null, null, '1');
INSERT INTO `t_keti` VALUES ('15', '01003', 'android运动助手', 'android平台软件开发', '可预订', '学术会议', '信息科学与技术系', 'no', '王菲', null, null, '4');
INSERT INTO `t_keti` VALUES ('16', '01004', '计算机信息安全分析', '分析信息安全', '可预订', '学术会议', '信息科学与技术系', 'no', '李飞', null, null, '5');
INSERT INTO `t_keti` VALUES ('17', '2016013001', '爬虫技术探讨', '爬虫技术探讨', '可预订', '学术会议', '信息科学与技术系', 'no', '李明', null, null, '1');
INSERT INTO `t_keti` VALUES ('18', '2016013102', '微信开发平台搭建', '微信开发平台搭建', '可预订', '学术沙龙', '信息科学与技术系', 'no', '李明', null, null, '1');-- ----------------------------
-- Table structure for `t_liuyan`
-- ----------------------------
DROP TABLE IF EXISTS `t_liuyan`;
CREATE TABLE `t_liuyan` (
`liuyan_id` int(11) DEFAULT NULL,
`liuyan_title` varchar(50) DEFAULT NULL,
`liuyan_date` varchar(50) DEFAULT NULL,
`liuyan_content` varchar(5000) DEFAULT NULL,
`liuyan_user` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_liuyan
-- ----------------------------
INSERT INTO `t_liuyan` VALUES ('1', '大家讨论一下讲座', '2016-1-21 23:22:11', '大家讨论一下讲座', '系统管理员');
INSERT INTO `t_liuyan` VALUES ('2', '好的一起讨论看看', '2016-1-30 22:58:51', '<p>好的一起讨论看看</p>', '10313101');-- ----------------------------
-- Table structure for `t_shipin`
-- ----------------------------
DROP TABLE IF EXISTS `t_shipin`;
CREATE TABLE `t_shipin` (
`shipin_id` int(11) DEFAULT NULL,
`shipin_name` varchar(66) DEFAULT NULL,
`shipin_jianjie` varchar(255) DEFAULT NULL,
`fujian` varchar(55) DEFAULT NULL,
`fujianYuanshiming` varchar(255) DEFAULT NULL,
`shijian` varchar(50) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_shipin
-- ----------------------------
INSERT INTO `t_shipin` VALUES ('1', 'oop基本原理教学视频', 'oop基本原理教学视频', '/upload/1336462829368.avi', '测试视频.avi', '2015-11-06 15:08', 'no');
INSERT INTO `t_shipin` VALUES ('2', 'jsp编程教程', 'jsp编程教程', '/upload/1368306660609.avi', '录像85.avi', '2015-11-23', 'yes');
INSERT INTO `t_shipin` VALUES ('3', '测试', '请输入内容', '/upload/1368306821203.avi', '录像87.avi', '2015-11-23', 'no');
INSERT INTO `t_shipin` VALUES ('4', '演示视频', '演示视频', '/upload/1368308488906.avi', '录像87.avi', '2015-11-23', 'no');
INSERT INTO `t_shipin` VALUES ('5', '教学录像', '<p>视频测试</p>', '/upload/1415845788625.avi', '录像90.avi', '2015-11-23', 'no');-- ----------------------------
-- Table structure for `t_stu`
-- ----------------------------
DROP TABLE IF EXISTS `t_stu`;
CREATE TABLE `t_stu` (
`stu_id` int(11) NOT NULL DEFAULT '0',
`stu_xuehao` varchar(50) DEFAULT NULL,
`stu_realname` varchar(50) DEFAULT NULL,
`stu_sex` varchar(50) DEFAULT NULL,
`stu_age` varchar(50) DEFAULT NULL,
`stu_card` varchar(50) DEFAULT NULL,
`stu_zhengzhimianmao` varchar(50) DEFAULT NULL,
`login_name` varchar(50) DEFAULT NULL,
`login_pw` varchar(50) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL,
`stu_jg` varchar(50) DEFAULT NULL,
`stu_xy` varchar(50) DEFAULT NULL,
`stu_zy` varchar(50) DEFAULT NULL,
`stu_bj` varchar(50) DEFAULT NULL,
`stu_rxsj` varchar(50) DEFAULT NULL,
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;-- ----------------------------
-- Records of t_xuanti
-- ----------------------------
INSERT INTO `t_xuanti` VALUES ('1', '15', '7', '同意', '0', 'no');
INSERT INTO `t_xuanti` VALUES ('2', '16', '8', '通过', '0', 'no');
INSERT INTO `t_xuanti` VALUES ('3', '17', '7', '申请中', '0', 'no');
[Err] INSERT INTO `t_user_role` VALUES ('2', '10', '1', '2017-09-12 21:28:32', '2017-09-12 21:28:32');
[Msg] Finished - Unsuccessfully总是这样,在阿里云数据倒是可以用