30 lines
788 B
SQL
30 lines
788 B
SQL
-- 修复工单名称字段长度限制
|
||
-- 问题：name 字段只有 20 个字符，无法存储较长的工单名称
|
||
-- 解决：将 name 字段扩展到 200 个字符
|
||
|
||
-- 1. 查看当前字段定义
|
||
SELECT
|
||
COLUMN_NAME,
|
||
COLUMN_TYPE,
|
||
CHARACTER_MAXIMUM_LENGTH,
|
||
COLUMN_COMMENT
|
||
FROM INFORMATION_SCHEMA.COLUMNS
|
||
WHERE TABLE_SCHEMA = DATABASE()
|
||
AND TABLE_NAME = 'test_work_order'
|
||
AND COLUMN_NAME = 'name';
|
||
|
||
-- 2. 修改字段长度
|
||
ALTER TABLE test_work_order
|
||
MODIFY COLUMN name VARCHAR(200) NOT NULL COMMENT '工单名称';
|
||
|
||
-- 3. 验证修改结果
|
||
SELECT
|
||
COLUMN_NAME,
|
||
COLUMN_TYPE,
|
||
CHARACTER_MAXIMUM_LENGTH,
|
||
COLUMN_COMMENT
|
||
FROM INFORMATION_SCHEMA.COLUMNS
|
||
WHERE TABLE_SCHEMA = DATABASE()
|
||
AND TABLE_NAME = 'test_work_order'
|
||
AND COLUMN_NAME = 'name';
|