Mysql examples

From lippmann wiki
Revision as of 15:19, 7 June 2015 by Maarten (Talk | contribs) (insert some values)

Jump to: navigation, 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' )