CREATE TABLE new_table_name (
col_a INT
, col_b INT
);
INSERT INTO new_table_name(col_a, col_b)
SELECT col_a, colb
FROM old_table_name;
DROP TABLE old_table_name;
INSERT INTO a(col1) SELECT col1 FROM b
b中的col1为字符123,a中的col1为整数可正确执行。