语法: alter table 表名 change 要修改的字段名 修改之后的字段名 字段类型
提示:要加上修改之后的字段名,否则报以下错误:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near '' at line 1
如果不想改变字段名,则直接写原来的字段名即可。
1、修改指定字段类型为datetime:
mysql> alter table fancy change s_edittime s_edittime datetime;
Query OK, 10 rows affected (0.24 sec)
Records: 10 Duplicates: 0 Warnings: 0