Mysql examples: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==add a column to a table== ALTER TABLE exports ADD level VARCHAR(20);") |
No edit summary |
||
| 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