MySQL 修改int型別為bigint SQL語句拼接

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';