How to rename mysql column from help to content in my table tbl_help
mysql_query("ALTER TABLE tbl_help " . "CHANGE COLUMN help content;");
views:
112answers:
2
+2
A:
From mySql Doc pages:
You can rename a column using a CHANGE old_col_name new_col_name column_definition clause.
psychotik
2009-10-31 20:54:44
thanks for the page. sorry, what is the column_definition? it's syntax like TEXT INT etc?
bob
2009-10-31 20:59:47
Yes, it's the type, constraints, etc. See http://dev.mysql.com/doc/refman/5.1/en/create-table.html for the exact definition.
Lukáš Lalinský
2009-10-31 21:04:41
@bob check the doc?
Mike B
2009-10-31 21:05:14
It's the column type, length, charset etc.
2009-10-31 21:05:41
@Mike B - Yeah.. getting blur. Actually I could not understand without fully examples.
bob
2009-10-31 21:09:20
This is all well and good, but does it screw up foreign keys, indexes and constraints?
rik.the.vik
2009-12-03 22:37:18
+2
A:
You've got to include the definition of the table 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) ;");
IronGoofy
2009-10-31 21:04:28