导入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文件了,认真看视频
012021-08-29
相似问题