转储的SQL文件运行错误
来源:4-4 自由编程
慕虎4211385
2020-10-23 20:24:52
# 具体遇到的问题
老师帮忙看看是什么问题。
创建了SQL数据表,转储出.SQL文件,再运行SQL文件出现错误,无法导入
导出的SQL:
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80021
Source Host : localhost:3306
Source Schema : goods
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 23/10/2020 20:16:35
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`price` float NOT NULL,
`desp` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '手机', 2000, '黑色,存储容量32G');
INSERT INTO `goods` VALUES (2, '冰箱', 1500, '银色,对开门');
INSERT INTO `goods` VALUES (3, '洗衣机', 3000, '滚筒');
INSERT INTO `goods` VALUES (4, '空调', 4000, '变频空调');
SET FOREIGN_KEY_CHECKS = 1;
# 报错信息的截图
[SQL] Query goods start
[ERR] 1046 - No database selected
[ERR] /*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80021
Source Host : localhost:3306
Source Schema : goods
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 23/10/2020 20:16:35
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`price` float NOT NULL,
`desp` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '手机', 2000, '黑色,存储容量32G');
INSERT INTO `goods` VALUES (2, '冰箱', 1500, '银色,对开门');
INSERT INTO `goods` VALUES (3, '洗衣机', 3000, '滚筒');
INSERT INTO `goods` VALUES (4, '空调', 4000, '变频空调');
SET FOREIGN_KEY_CHECKS = 1;
[SQL] Finished with error
# 相关课程内容截图
# 尝试过的解决思路和结果
# 粘贴全部相关代码,切记添加代码注释(请勿截图)
在这里输入代码,可通过选择【代码语言】突出显示
1回答
相似问题