Navicat 运行SQL文件报错，求解

[SQL] Query rlzy start
[ERR] [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]'=' 附近有语法错误。 (102)

[ERR] /*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : rlzy

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2018-05-08 17:23:43
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(55) DEFAULT NULL,
  `userPw` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'a', 'aa');

-- ----------------------------
-- Table structure for `t_chuqin`
-- ----------------------------
DROP TABLE IF EXISTS `t_chuqin`;
CREATE TABLE `t_chuqin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yuefen` varchar(55) DEFAULT NULL,
  `tianshu` int(11) DEFAULT NULL,
  `yuangong_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_chuqin
-- ----------------------------
INSERT INTO `t_chuqin` VALUES ('7', '2017-04', '16', '20');
INSERT INTO `t_chuqin` VALUES ('8', '2017-04', '15', '19');
INSERT INTO `t_chuqin` VALUES ('11', '2017-05', '22', '22');
INSERT INTO `t_chuqin` VALUES ('12', '2017-05', '21', '23');
INSERT INTO `t_chuqin` VALUES ('13', '2017-05', '22', '23');
INSERT INTO `t_chuqin` VALUES ('14', '2017-06', '22', '23');

-- ----------------------------
-- Table structure for `t_gongzi`
-- ----------------------------
DROP TABLE IF EXISTS `t_gongzi`;
CREATE TABLE `t_gongzi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yuefen` varchar(55) DEFAULT NULL,
  `jine` int(11) DEFAULT NULL,
  `yuangong_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_gongzi
-- ----------------------------
INSERT INTO `t_gongzi` VALUES ('6', '2017-04', '2000', '20');
INSERT INTO `t_gongzi` VALUES ('7', '2017-04', '1900', '19');
INSERT INTO `t_gongzi` VALUES ('9', '2017-05', '2200', '22');
INSERT INTO `t_gongzi` VALUES ('10', '2017-05', '2100', '23');
INSERT INTO `t_gongzi` VALUES ('11', '2017-05', '2000', '20');

-- ----------------------------
-- Table structure for `t_organization`
-- ----------------------------
DROP TABLE IF EXISTS `t_organization`;
CREATE TABLE `t_organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `p_id` int(11) DEFAULT NULL,
  `del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_organization
-- ----------------------------
INSERT INTO `t_organization` VALUES ('1', '后勤部', '后勤部', '0', 'no');
INSERT INTO `t_organization` VALUES ('2', '生产部', '生产部', '0', 'no');
INSERT INTO `t_organization` VALUES ('3', '生产一部', '生产一部', '2', 'no');
INSERT INTO `t_organization` VALUES ('4', '生产二部', '生产二部', '2', 'no');
INSERT INTO `t_organization` VALUES ('5', '人事部', '人事部', '0', 'yes');
INSERT INTO `t_organization` VALUES ('6', '组织部', '组织部', '0', 'yes');
INSERT INTO `t_organization` VALUES ('7', '后勤一部', '后勤一部', '1', 'no');
INSERT INTO `t_organization` VALUES ('8', '后勤二部', '后勤二部', '1', 'no');
INSERT INTO `t_organization` VALUES ('10', '人事一部', '人事一部', '5', 'yes');
INSERT INTO `t_organization` VALUES ('11', '11', '11', '4', 'no');
INSERT INTO `t_organization` VALUES ('12', '生产三部', '生产三部', '2', 'yes');
INSERT INTO `t_organization` VALUES ('13', '22', '22', '4', 'no');
INSERT INTO `t_organization` VALUES ('14', '生产三部', '', '0', 'yes');
INSERT INTO `t_organization` VALUES ('15', '33', '', '4', 'yes');
INSERT INTO `t_organization` VALUES ('16', '生产三部', '', '0', 'yes');
INSE
[SQL] Finished with error

这个？

还是说是版本问题，执行的时候会把错误报出来的

检查一下是不是有什么地方粘贴多了或者少了。

我的sql文件数据第一段落是两行

int类型不要用单引号

• 你看下这篇博客吧, 应该有用👉 ：navicat运行sql文件时错误

你连的数据库是sqlserver，但是sql文件里的sql语法又是mysql的，所以会报错