sql - MySQL - Altering Column Types -

sql - MySQL - Altering Column Types -

using mysql, given table (named "table1") 3 known named columns (e.g "column1", "column2" , "column3") , unknown number of unknown named columns, how set type of unknown columns varchar(40) sql statement(s)?

just generate statements need , run them

select concat('alter table ', table_name, ' modify column ', column_name, ' varchar(40)') information_schema.columns table_schema='yourdb' , table_name='table1' , column_name not in('col1','col2','col3')

mysql sql