Skip to content

Instantly share code, notes, and snippets.

@arkadiusjonczek
Created June 3, 2018 23:31
Show Gist options
  • Save arkadiusjonczek/2dcbbafdcdca46202e578a3fd878b0ae to your computer and use it in GitHub Desktop.
Save arkadiusjonczek/2dcbbafdcdca46202e578a3fd878b0ae to your computer and use it in GitHub Desktop.
Select IDs from Tabel and create comma separated list as CSV #tags: MySQL
SELECT DISTINCT uid
FROM tt_news
ORDER BY uid
INTO OUTFILE '/tmp/uids.csv'
LINES TERMINATED BY ',';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment