nest-admin icon indicating copy to clipboard operation
nest-admin copied to clipboard

Published 20 hours ago • verified publisher icon buqiyuan

sql文件无法导入

Open ryiot opened this issue 2 years ago • 5 comments

image

Bug report（问题描述）

Steps to reproduce（问题复现步骤）

Screenshot or Gif（截图或动态图）

Link to minimal reproduction（最小可在线还原demo）

Other relevant information（格外信息）

  • Your OS:
  • Node.js version:
  • Mysql version:
  • Redis version:

ryiot avatar Jun 04 '22 14:06 ryiot

我的也是

Sunny-liaokai avatar Jun 17 '22 08:06 Sunny-liaokai

🤔MySQL版本是8.x以上吗？

buqiyuan avatar Jun 28 '22 16:06 buqiyuan

🤔MySQL版本是8.x以上吗？

mysql 5.7.x

ryiot avatar Jul 12 '22 08:07 ryiot

应该是字符集根数据库不一样才不能导入吧，比如我的就是改成了COLLATE=utf8mb4_general_ci;就导入成功了

axelulu avatar Aug 31 '22 06:08 axelulu

我遇到Unknown collation: 'utf8mb4_0900_ai_ci'，将 5.7 换成 8.0 可以了。

YuQian2015 avatar Sep 11 '22 04:09 YuQian2015

sql文件有误，表建好了，但是insert那里加不进去数据

semyin avatar Oct 10 '23 10:10 semyin

sql文件有误，表建好了，但是insert那里加不进去数据

INSERT INTO sys_user VALUES ('2020-08-27 03:38:30.000000','2022-03-28 22:52:11.845930',1,1,'路飞','rootadmin','ccdb5f7e5be14fe0c0528974428f79f9','','https://buqiyuan.gitee.io/img/logo.jpg','[email protected]','15622472425',NULL,'xQYCspvFb8cAW6GG1pOoUGTLqsuUSO3d',1),('2021-12-07 09:29:18.844687','2022-07-31 00:07:00.332032',6,2,'路飞','luffyfe','a201c32f60232acaf95d9eb74926c8aa','草帽小子',NULL,'[email protected]','1355355646','嘿嘿嘿','WdE7MrslDYt02ZNkGo4asBhpXXY57wzi',1),('2022-09-19 20:25:20.362095','2022-09-19 20:25:20.362095',21,5,'543253245','lamp523453','49b28678aac0064f38a881b1e6b0a644',NULL,NULL,'','','','IC2yKu1eWyM4lwmholpLgftFZVtBozmX',1),('2022-09-19 20:25:36.573561','2022-09-19 20:25:36.573561',22,2,'3425253','lamp555','cef7a31ba95492a376ef4dd5e56a7610',NULL,NULL,'','','','QRMRwVfZWCQXv9kCdCgTs5wKWNjdNEFn',1);

semyin avatar Oct 10 '23 10:10 semyin

sql文件有误，表建好了，但是insert那里加不进去数据

INSERT INTO sys_user_role VALUES ('2020-09-14 04:10:34.371646','2020-09-14 04:10:34.371646',1,1,1),('2022-07-31 00:07:00.494619','2022-07-31 00:07:00.494619',18,6,2),('2022-09-19 20:25:20.375153','2022-09-19 20:25:20.375153',65,21,4),('2022-09-19 20:25:36.580258','2022-09-19 20:25:36.580258',66,22,3);

实际上第二条数据会报psalt不能为null

sql文件有误，表建好了，但是insert那里加不进去数据

INSERT INTO sys_user VALUES ('2020-08-27 03:38:30.000000','2022-03-28 22:52:11.845930',1,1,'路飞','rootadmin','ccdb5f7e5be14fe0c0528974428f79f9','','https://buqiyuan.gitee.io/img/logo.jpg','[email protected]','15622472425',NULL,'xQYCspvFb8cAW6GG1pOoUGTLqsuUSO3d',1),('2021-12-07 09:29:18.844687','2022-07-31 00:07:00.332032',6,2,'路飞','luffyfe','a201c32f60232acaf95d9eb74926c8aa','草帽小子',NULL,'[email protected]','1355355646','嘿嘿嘿','WdE7MrslDYt02ZNkGo4asBhpXXY57wzi',1),('2022-09-19 20:25:20.362095','2022-09-19 20:25:20.362095',21,5,'543253245','lamp523453','49b28678aac0064f38a881b1e6b0a644',NULL,NULL,'','','','IC2yKu1eWyM4lwmholpLgftFZVtBozmX',1),('2022-09-19 20:25:36.573561','2022-09-19 20:25:36.573561',22,2,'3425253','lamp555','cef7a31ba95492a376ef4dd5e56a7610',NULL,NULL,'','','','QRMRwVfZWCQXv9kCdCgTs5wKWNjdNEFn',1);

实际上第三条就会报psalt不能为null

semyin avatar Oct 10 '23 10:10 semyin