Difference between revisions of "Mysql examples"
From lippmann wiki
| 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' )
