check the manual that corresponds to yourMySQL server version for the right syntax touse near ' /*
求大神解答一下错在哪里,万分感谢,以下是全部信息。[Err]1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatco...
求大神解答一下错在哪里,万分感谢,以下是全部信息。
[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 Transfer
Source Server : localhost_3306
So' at line 1
[Err] /*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50717
Source Host : localhost:3306
Source Database : testdbb
Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001
Date: 2017-08-09 23:22:35
*/
DROP DATABASE IF EXISTS `testdbb`;
CREATE DATABASE testdbb;
USE testdbb;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `person`
-- ----------------------------
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(50) NOT NULL,
`sex` varchar(2) NOT NULL,
`age` int(10) NOT NULL,
`nation` varchar(50) NOT NULL,
`address` varchar(100) NOT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of person
-- ----------------------------
INSERT INTO `person` VALUES ('123456', '张三', 'f', '12', '汉族', '福州市');
INSERT INTO `person` VALUES ('55666', '王五', 'm', '66', '苗族', '马山');
INSERT INTO `person` VALUES ('666666@qq.com', '淑芬', 'm', '66', '苗族', '福建省');
[Msg] Finished - Unsuccessfully
-------------------------------------------------- 展开
[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 Transfer
Source Server : localhost_3306
So' at line 1
[Err] /*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50717
Source Host : localhost:3306
Source Database : testdbb
Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001
Date: 2017-08-09 23:22:35
*/
DROP DATABASE IF EXISTS `testdbb`;
CREATE DATABASE testdbb;
USE testdbb;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `person`
-- ----------------------------
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(50) NOT NULL,
`sex` varchar(2) NOT NULL,
`age` int(10) NOT NULL,
`nation` varchar(50) NOT NULL,
`address` varchar(100) NOT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of person
-- ----------------------------
INSERT INTO `person` VALUES ('123456', '张三', 'f', '12', '汉族', '福州市');
INSERT INTO `person` VALUES ('55666', '王五', 'm', '66', '苗族', '马山');
INSERT INTO `person` VALUES ('666666@qq.com', '淑芬', 'm', '66', '苗族', '福建省');
[Msg] Finished - Unsuccessfully
-------------------------------------------------- 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询