Thursday, 17 May 2012

mysql cheatsheet


# Print the query result into a file
mysql> select * into outfile '/tmp/new.txt' from users;

# show the current database
mysql> select database();

No comments:

Post a Comment