Mysql examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 10: | Line 10: | ||
INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' ) | INSERT INTO exports (hostname, export) VALUES('fuego', 'sec=sys,rw' ) | ||
== output to csv == | |||
echo SELECT \* FROM employees INTO OUTFILE \'/tmp/employees.csv\' FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' | mysql -u root -p company | |||
Revision as of 17:26, 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' )
output to csv
echo SELECT \* FROM employees INTO OUTFILE \'/tmp/employees.csv\' FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' | mysql -u root -p company