Mysql examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
ALTER TABLE exports CHANGE hostname name INT | ALTER TABLE exports CHANGE hostname name INT | ||
==insert some values== | |||
INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' ) | |||
Revision as of 14:51, 7 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
insert some values
INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' )