Navicat突然就不能运行下载下来的sql文件是什么原因啊

来源:2-1 JDBC的特点

宋舒

2020-07-08 08:58:31

[SQL] Query imooc start

[ERR] 1046 - No database selected

[ERR] /*

 Navicat Premium Data Transfer


 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 80016

 Source Host           : localhost:3306

 Source Schema         : imooc


 Target Server Type    : MySQL

 Target Server Version : 80016

 File Encoding         : 65001


 Date: 24/02/2020 17:13:16

*/


SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;


-- ----------------------------

-- Table structure for employee

-- ----------------------------

DROP TABLE IF EXISTS `employee`;

CREATE TABLE `employee`  (

  `eno` int(11) NOT NULL,

  `ename` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

  `salary` float(10, 2) NOT NULL,

  `dname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

  `hiredate` date NULL DEFAULT NULL,

  PRIMARY KEY (`eno`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;


-- ----------------------------

-- Records of employee

-- ----------------------------

INSERT INTO `employee` VALUES (1000, '员工1000', 5000.00, '市场部', '1992-03-04');

INSERT INTO `employee` VALUES (1001, '员工1001', 3500.00, '市场部', '1988-02-18');

INSERT INTO `employee` VALUES (1002, '员工1002', 4000.00, '市场部', '1996-02-01');

INSERT INTO `employee` VALUES (1003, '员工1003', 4000.00, '市场部', '2001-08-21');

INSERT INTO `employee` VALUES (1004, '员工1004', 4000.00, '市场部', '2003-01-02');

INSERT INTO `employee` VALUES (1005, '员工1005', 4000.00, '市场部', '1996-07-28');

INSERT INTO `employee` VALUES (1006, '员工1006', 4000.00, '市场部', '1999-12-30');

INSERT INTO `employee` VALUES (1007, '员工1007', 4000.00, '市场部', '2009-05-30');

INSERT INTO `employee` VALUES (1008, '员工1008', 4000.00, '市场部', '1984-05-30');

INSERT INTO `employee` VALUES (1009, '员工1009', 4000.00, '市场部', '2004-05-07');

INSERT INTO `employee` VALUES (3308, '张三', 6000.00, '研发部', '2011-05-08');

INSERT INTO `employee` VALUES (3420, '李四', 8700.00, '研发部', '2006-11-11');

INSERT INTO `employee` VALUES (3610, '王五', 4550.00, '市场部', '2009-10-01');


SET FOREIGN_KEY_CHECKS = 1;

[SQL] Finished with error


MySQL 和Navicat 都重新安装了还是不行   请问怎么解决啊 

写回答

1回答

好帮手慕小尤

2020-07-08

同学你好,1. 错误提示:没有选择数据库,如下图所示:

http://img.mukewang.com/climg/5f0690610950c3f304160182.jpg

建议同学先选择数据库,然后再运行SQL文件。如下所示:

http://img.mukewang.com/climg/5f052fae0948d69301670316.jpg

2. 同学可尝试使用Navicat工具中的查询进行引入。如下所示:

http://img.mukewang.com/climg/5f052e6b098aae3404300198.jpg

http://img.mukewang.com/climg/5f052fec09b72d5304000184.jpg

如果我的回答解决了你的疑惑,请采纳!祝学习愉快!

0

0 学习 · 16556 问题

查看课程