qconline/doc/sql/check_qc_standard_factor.sql

-- 检查 qc_standard_factor 表当前结构
USE `pacsonline_new`;

DESCRIBE `qc_standard_factor`;

-- 查看当前表的所有字段
SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'qc_standard_factor'
AND TABLE_SCHEMA = 'pacsonline_new'
ORDER BY ORDINAL_POSITION;