RuoYi icon indicating copy to clipboard operation
RuoYi copied to clipboard

mysql 命令行执行 sql/ry_20240601.sql 报错

Open Onlylonger opened this issue 5 months ago • 0 comments

期望

希望ry初始化表结构和数据

结果

当使用 mysql -u root -p ry < ./sql/ry_20240601.sql 执行的时候,报错提示 ERROR 1406 (22001) at line 27: Data too long for column 'dept_name' at row 1

截图如下:

image

mysql版本以及步骤:

$ mysql --version
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe  Ver 8.0.39 for Win64 on x86_64 (MySQL Community Server - GPL)
  1. git clone https://github.com/yangzongzhuan/RuoYi.git
  2. IDEA terminal 新建 git bash 命令行窗口
  3. 执行 mysql -u root -p ry < ./sql/ry_20240601.sql

Onlylonger avatar Sep 22 '24 07:09 Onlylonger