Mysql examples

From lippmann wiki
Revision as of 14:51, 7 June 2015 by Maarten (Talk | contribs)

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' )