转储的SQL文件运行错误
# 具体遇到的问题
老师帮忙看看是什么问题。
创建了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
# 相关课程内容截图
# 尝试过的解决思路和结果
# 粘贴全部相关代码,切记添加代码注释(请勿截图)
在这里输入代码,可通过选择【代码语言】突出显示
正在回答
- 参与学习 人
- 提交作业 9410 份
- 解答问题 16556 个
综合就业常年第一,编程排行常年霸榜,无需脱产即可学习,北上广深月薪过万 无论你是未就业的学生还是想转行的在职人员,不需要基础,只要你有梦想,想高薪
了解课程
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星