导入SQL文件不成功

来源:1-2 搭建开发环境

寻一把未历沧桑的土壤

2021-08-28

老师,为什么导入SQL文件不成功呢,如下:不能顺利导入,报错了。

[SQL] Query 数据库 start
[ERR] 1046 - No database selected
[ERR] /*
Navicat Premium Data Transfer

Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 50721
Source Host : localhost:3306
Source Schema : emos

Target Server Type : MySQL
Target Server Version : 50721
File Encoding : 65001

Date: 22/08/2021 23:57:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


– Table structure for act_evt_log


DROP TABLE IF EXISTS act_evt_log;
CREATE TABLE act_evt_log (
LOG_NR_ bigint(20) NOT NULL AUTO_INCREMENT,
TYPE_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
TIME_STAMP_ timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
DATA_ longblob NULL,
LOCK_OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
LOCK_TIME_ timestamp(3) NULL DEFAULT NULL,
IS_PROCESSED_ tinyint(4) NULL DEFAULT 0,
PRIMARY KEY (LOG_NR_) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;


– Records of act_evt_log



– Table structure for act_ge_bytearray


DROP TABLE IF EXISTS act_ge_bytearray;
CREATE TABLE act_ge_bytearray (
ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
REV_ int(11) NULL DEFAULT NULL,
NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
DEPLOYMENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
BYTES_ longblob NULL,
GENERATED_ tinyint(4) NULL DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE,
INDEX ACT_FK_BYTEARR_DEPL(DEPLOYMENT_ID_) USING BTREE,
CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES act_re_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;


– Records of act_ge_bytearray


INSERT INTO act_ge_bytearray VALUES (‘aa37fec5-0361-11ec-88f3-24418c063510’, 1, ‘D:\IdeaProjects\emos-workflow\target\classes\processes\meeting.bpmn20.xml’, ‘aa37fec4-0361-11ec-88f3-24418c063510’, 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0D0A3C62706D6E323A646566696E6974696F6E7320786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E6365220D0A20202020202020202020202020202020202020786D6C6E733A62706D6E323D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C220D0A20202020202020202020202020202020202020786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4449220D0A20202020202020202020202020202020202020786D6C6E733A64633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F4449220D0A20202020202020202020202020202020202020786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E222069643D226469616772616D5F50726F636573735F31363139393735353237393037220D0A202020202020202020202020202020202020207461726765744E616D6573706163653D22687474703A2F2F62706D6E2E696F2F736368656D612F62706D6E220D0A202020202020202020202020202020202020207873693A736368656D614C6F636174696F6E3D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2042504D4E32302E787364223E0D0A202020203C62706D6E323A70726F636573732069643D226D656
[ERR] 1046 - No database selected
[ERR]
INSERT INTO tb_city VALUES (141, ‘克孜勒苏市’, ‘kzls’);
INSERT INTO tb_city VALUES (142, ‘六安市’, ‘la’);
INSERT INTO tb_city VALUES (143, ‘来宾市’, ‘lb’);
INSERT INTO tb_city VALUES (144, ‘聊城市’, ‘lc’);
INSERT INTO tb_city VALUES (145, ‘娄底市’, ‘ld’);
INSERT INTO tb_city VALUES (146, ‘乐山市’, ‘leshan’);
INSERT INTO tb_city VALUES (147, ‘廊坊市’, ‘lf’);
INSERT INTO tb_city VALUES (148, ‘漯河市’, ‘lh’);
INSERT INTO tb_city VALUES (149, ‘凉山市’, ‘liangshan’);
INSERT INTO tb_city VALUES (150, ‘辽阳市’, ‘liaoyang’);
INSERT INTO tb_city VALUES (151, ‘辽源市’, ‘liaoyuan’);
INSERT INTO tb_city VALUES (152, ‘临沧市’, ‘lincang’);
INSERT INTO tb_city VALUES (153, ‘临汾市’, ‘linfen’);
INSERT INTO tb_city VALUES (154, ‘临沂市’, ‘linyi’);
INSERT INTO tb_city VALUES (155, ‘丽水市’, ‘lishui’);
INSERT INTO tb_city VALUES (156, ‘柳州市’, ‘liuzhou’);
INSERT INTO tb_city VALUES (157, ‘丽江市’, ‘lj’);
INSERT INTO tb_city VALUES (158, ‘吕梁市’, ‘ll’);
INSERT INTO tb_city VALUES (159, ‘陇南市’, ‘ln’);
INSERT INTO tb_city VALUES (160, ‘龙岩市’, ‘longyan’);
INSERT INTO tb_city VALUES (161, ‘六盘水市’, ‘lps’);
INSERT INTO tb_city VALUES (162, ‘泸州市’, ‘luzhou’);
INSERT INTO tb_city VALUES (163, ‘洛阳市’, ‘ly’);
INSERT INTO tb_city VALUES (164, ‘连云港市’, ‘lyg’);
INSERT INTO tb_city VALUES (165, ‘兰州市’, ‘lz’);
INSERT INTO tb_city VALUES (166, ‘马鞍山市’, ‘mas’);
INSERT INTO tb_city VALUES (167, ‘牡丹江市’, ‘mdj’);
INSERT INTO tb_city VALUES (168, ‘茂名市’, ‘mm’);
INSERT INTO tb_city VALUES (169, ‘眉山市’, ‘ms’);
INSERT INTO tb_city VALUES (170, ‘绵阳市’, ‘my’);
INSERT INTO tb_city VALUES (171, ‘梅州市’, ‘mz’);
INSERT INTO tb_city VALUES (172, ‘南充市’, ‘nanchong’);
INSERT INTO tb_city VALUES (173, ‘宁波市’, ‘nb’);
INSERT INTO tb_city VALUES (174, ‘南昌市’, ‘nc’);
INSERT INTO tb_city VALUES (175, ‘宁德市’, ‘nd’);
INSERT INTO tb_city VALUES (176, ‘内江市’, ‘neijiang’);
INSERT INTO tb_city VALUES (177, ‘南京市’, ‘nj’);
INSERT INTO tb_city VALUES (178, ‘南宁市’, ‘nn’);
INSERT INTO tb_city VALUES (179, ‘南平市’, ‘np’);
INSERT INTO tb_city VALUES (180, ‘南通市’, ‘nt’);
INSERT INTO tb_city VALUES (181, ‘怒江市’, ‘nujiang’);
INSERT INTO tb_city VALUES (182, ‘南阳市’, ‘ny’);
INSERT INTO tb_city VALUES (183, ‘平顶山市’, ‘pds’);
INSERT INTO tb_city VALUES (184, ‘普洱市’, ‘pe’);
INSERT INTO tb_city VALUES (185, ‘盘锦市’, ‘pj’);
INSERT INTO tb_city VALUES (186, ‘平凉市’, ‘pl’);
INSERT INTO tb_city VALUES (187, ‘莆田市’, ‘pt’);
INSERT INTO tb_city VALUES (188, ‘萍乡市’, ‘px’);
INSERT INTO tb_city VALUES (189, ‘濮阳市’, ‘py’);
INSERT INTO tb_city VALUES (190, ‘攀枝花市’, ‘pzh’);
INSERT INTO tb_city VALUES (191, ‘青岛市’, ‘qd’);
INSERT INTO tb_city VALUES (192, ‘黔东南市’, ‘qdn’);
INSERT INTO tb_city VALUES (193, ‘秦皇岛市’, ‘qhd’);
INSERT INTO tb_city VALUES (194, ‘潜江市’, ‘qianjiang’);
INSERT INTO tb_city VALUES (195, ‘庆阳市’, ‘qingyang’);
INSERT INTO tb_city VALUES (196, ‘钦州市’, ‘qinzhou’);
INSERT INTO tb_city VALUES (197, ‘曲靖市’, ‘qj’);
INSERT INTO tb_city VALUES (198, ‘黔南市’, ‘qn’);
INSERT INTO tb_city VALUES (199, ‘齐齐哈尔市’, ‘qqhr’);
INSERT INTO tb_city VALUES (200, ‘七台河市’, ‘qth’);
INSERT INTO tb_city VALUES (201, ‘衢州市’, ‘quzhou’);
INSERT INTO tb_city VALUES (202, ‘黔西南市’, ‘qxn’);
INSERT INTO tb_city VALUES (203, ‘清远市’, ‘qy’);
INSERT INTO tb_city VALUES (204, ‘泉州市’, ‘qz’);
INSERT INTO tb_city VALUES (205, ‘日照市’, ‘rz’);
INSERT INTO tb_city VALUES (206, ‘三亚市’, ‘sanya’);
INSERT INTO tb_city VALUES (207, ‘韶关市’, ‘sg’);
INSERT INTO tb_city VALUES (208, ‘上海市’, ‘sh’);
INSERT INTO tb_city VALUES (209, ‘邵阳市’, ‘shaoyang’);
INSERT INTO tb_city VALUES (210, ‘十堰市’, ‘shiyan’);
INSERT INTO tb_city VALUES (211, ‘朔州市’, ‘shuozhou’);
INSERT INTO tb_city VALUES (212, ‘石家庄市’, ‘sjz’);
INSERT INTO tb_city VALUES (213, ‘商洛市’, ‘sl’);
INSERT INTO tb_city VALUES (214, ‘三明市’, ‘sm’);
INSERT INTO tb_city VALUES (215, ‘三门峡市’, ‘smx’);
INSERT INTO tb_city VALUES (216, ‘神农架市’, ‘snj’);
INSERT INTO tb_city VALUES (217, ‘松原市’, ‘songyuan’);
INSERT INTO tb_city VALUES (218, ‘四平市’, ‘sp’);
INSERT INTO tb_city VALUES (219, ‘商丘市’, ‘sq’);
INSERT INTO tb_city VALUES (220, ‘上饶市’, ‘sr’);
INSERT INTO `tb_ci
[SQL] Finished with error

写回答

1回答

神思者

2021-08-28

你没创建逻辑库就导入sql文件了,认真看视频

0
1
寻一把未历沧桑的土壤
老师,并不是没有创建逻辑库,好像是由于使用的是电脑上之前的MySQL5.X的版本,由于语法不兼容导致的
2021-08-29
共1条回复

SpringBoot+Vue3 项目实战,打造企业级在线办公系统

以业务为基础,贯穿前后端技术栈,获得企业级项目开发经验

2231 学习 · 1257 问题

查看课程