-- 检查withdraw表结构 SHOW CREATE TABLE withdraw; -- 查看表字段详情 DESC withdraw; -- 查看表的约束 SELECT COLUMN_NAME, IS_NULLABLE, DATA_TYPE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'peidu' AND TABLE_NAME = 'withdraw' ORDER BY ORDINAL_POSITION;