Mysql examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 9: | Line 9: | ||
==insert some values== | ==insert some values== | ||
INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' ) | INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' ) | ||
Revision as of 15:19, 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' )