Advertisement
ran5000

Untitled

Oct 19th, 2012
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT id,status_twitter_id,twitter_id, creator_twitter_identity_id, REPLACE(text,'\n','\\n'), in_reply_to_status_id, in_reply_to_user_id, REPLACE(urls,'\n','\\n'), REPLACE(hashtags,'\n','\\n'), created_at, updated_at, sent_at, REPLACE(user_mentions,'\n','\\n') FROM twitter_statuses into outfile '/tmp/twitter_statuses.csv'  FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement