Mysql examples

From lippmann wiki
Revision as of 16:02, 3 June 2015 by Maarten (Talk | contribs)

Jump to: navigation, search

add a column to a table

ALTER TABLE exports ADD level VARCHAR(20);

rename or change a colume data type

ALTER TABLE exports CHANGE hostname name  INT