MySQL - 重命名列

Question

How to rename mysql column from help to content in my table tbl_help

mysql_query("ALTER TABLE tbl_help " . "CHANGE COLUMN help content;");

Answer 1

You've got to include the definition of the column in the change column statement (not sure why, but that's what the documentation says.)

So this should work:

mysql_query("ALTER TABLE tbl_help " . "CHANGE COLUMN help content VARCHAR(200) ;");