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
