Skip to content

Instantly share code, notes, and snippets.

@rohit-gupta

rohit-gupta/dump_photoid_text.sql

Last active March 1, 2023 05:13
Show Gist options
  • Save rohit-gupta/829018601c4cde29f8abdc8cec73f63b to your computer and use it in GitHub Desktop.
Save rohit-gupta/829018601c4cde29f8abdc8cec73f63b to your computer and use it in GitHub Desktop.
Download ZIP
dump photoid, url, title and description from yfcc100m metadata file
Raw
dump_photoid_text.sql
.open yfcc100m_dataset.sql
.databases
.tables
.schema yfcc100m_dataset
SELECT * from yfcc100m_dataset WHERE photoid=2932067831 LIMIT 1;
.mode csv
.headers on
.out yfcc100m_dump.csv
SELECT photoid, title, description, downloadurl FROM yfcc100m_dataset;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment