Difference between revisions of "Mysql examples"

From lippmann wiki
Jump to: navigation, search
(output to csv)
Line 1: Line 1:
 +
==Change the password of a user==
 +
 +
SET PASSWORD FOR 'user'@'host' = PASSWORD('new pw');
 +
 
==add a column to a table==
 
==add a column to a table==
  

Revision as of 21:58, 7 June 2015

Change the password of a user

SET PASSWORD FOR 'user'@'host' = PASSWORD('new pw');

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

Directly from the mysql cli, or when piped to the mysql client:

SELECT * FROM employees INTO OUTFILE '/tmp/employees.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'

With echo in a single line:

echo SELECT \* FROM employees   INTO OUTFILE  \'/tmp/employees.csv\' FIELDS TERMINATED BY \',\' ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' | mysql -u root -p company