SELECT
CONCAT(
"alter table ",
TABLE_SCHEMA,
".",
TABLE_NAME,
" modify ",
COLUMN_NAME,
" bigint(20)",
IF
( IS_NULLABLE = 'NO', " NOT NULL", "" ),
IF
( EXTRA = "", "", " AUTO_INCREMENT" ),
IF
( COLUMN_DEFAULT IS NULL, "", CONCAT( " DEFAULT ", COLUMN_DEFAULT ) ),
IF
( COLUMN_COMMENT = "", "", CONCAT( " COMMENT '", COLUMN_COMMENT, "'" ) ),
";"
) AS alter_sql
FROM
information_schema.COLUMNS
WHERE
( COLUMN_NAME = 'orderid' OR COLUMN_NAME = 'order_id' )
AND DATA_TYPE = 'int';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28939273/viewspace-2682362/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
