Difference between revisions of "Mysql examples"

From lippmann wiki
Jump to: navigation, search
(insert some values)
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' )