Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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