Skip to content

Instantly share code, notes, and snippets.

@pleebe

pleebe/gist:cefffe00ed8d9b2f29b75bf9ae2c120c

Created May 5, 2017 21:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pleebe/cefffe00ed8d9b2f29b75bf9ae2c120c to your computer and use it in GitHub Desktop.
Save pleebe/cefffe00ed8d9b2f29b75bf9ae2c120c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT `num`, `subnum`, `thread_num`, `op`, `timestamp`, `timestamp_expired`, `preview_orig`, `preview_w`, `preview_h`, `media_filename`, `media_w`, `media_h`, `media_size`, `media_hash`, `media_orig`, `spoiler`, `deleted`, `capcode`, `email`, `name`, `trip`, `title`, `comment`, `sticky`, `locked`, `poster_hash`, `poster_country`, `exif`
FROM `board`
INTO OUTFILE "board.csv"
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY "\n";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment