Use /tmp, as mySql doesn't have write privileges everywhere.
select * into outfile '/tmp/outfile.txt' fields terminated by ',' from my_table_name;
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
You need to create an account or log in to post comments to this site.
» Creating a MySQL database an... in mysql databases users
» SSH tunneling for MySQL in mysql ssh tunneling remote
» MySQL launchd item for Mac O... in mysql osx 10.4 tiger launchd
» Creating a quick dump for yo... in mysql
» Looking for the MySQL socket in mysql
» Convert a db to UTF8 after u... in mysql
Snippets (source code soon to be available) developed by Peter Cooper and powered by Ruby On Rails