Click to See Complete Forum and Search --> : (Easy enough) How to rename a mysql field


basketmen
01-26-2009, 12:34 PM
in this picture i want to change "Recent Blog Entries" to just "Blog"

http://i291.photobucket.com/albums/ll284/basketmen/renamemysqlfields.jpg









how to make it guys, or what command i need to run, there is no edit button there (thats like usually showing in table edit)

scragar
01-26-2009, 12:44 PM
ALTER TABLE `tblName`CHANGE `oldField` `newFieldName` FieldDef

chazzy
01-26-2009, 07:38 PM
UPDATE zp_entemodule_link SET title='new value' where title='old value';


based on what you've posted, you want to change the value of a column for a particular row, or set of rows, rather than renaming anything in the table. let me know if not.