Skip to content

Instantly share code, notes, and snippets.

@svperfecta

svperfecta/MySQL Tips

Created February 2, 2011 20:21
Show Gist options
  • Save svperfecta/808348 to your computer and use it in GitHub Desktop.
Save svperfecta/808348 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL Tips
# Export a query to CSV
mysql> create table user_video_for_brightcove engine=CSV SELECT user_id, title, description, time_created, file_name, is_private, status_mlg, parent_user_video_id FROM user_video where parent_user_video_id = 0 and status_mlg = 'active';
Query OK, 112176 rows affected (1.73 sec)
Records: 112176 Duplicates: 0 Warnings: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment