Difference between revisions of "Mysql examples"
From lippmann wiki
(Created page with "==add a column to a table== ALTER TABLE exports ADD level VARCHAR(20);") |
|||
Line 1: | Line 1: | ||
==add a column to a table== | ==add a column to a table== | ||
− | ALTER TABLE exports ADD level VARCHAR(20); | + | ALTER TABLE exports ADD level VARCHAR(20); |
+ | |||
+ | ==rename or change a colume data type== | ||
+ | |||
+ | ALTER TABLE exports CHANGE hostname name INT |
Revision as of 16:02, 3 June 2015
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