Mysql examples
Jump to navigation
Jump to search
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' )