July, 2011

How to Delete a Field in a MySQL Table

27 July , 2011 Bill MySQL Database

To delete a column in a MySQL database column, use the DROP COLUMN keywords with ALTER TABLE. Do not mistake deleting a field for deleting a record.

More

1 how to, linux, mysql, osx, server,

How to Rename a Field in a MySQL Table

27 July , 2011 Bill MySQL Database

To change the name of a field in a MySQL database table use the CHANGE keyword with ALTER TABLE. You must also supply the field type again or you can change that too in the same line. Example: ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);

More

0 how to, linux, mysql, osx, server,

Powered by WordPress. Designed by elogi.