Showing posts with label db. Show all posts
Showing posts with label db. Show all posts

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();