Skip to content

Instantly share code, notes, and snippets.

@ollyja

ollyja/dump sql output to file in csv

Created January 30, 2018 04:30
Show Gist options
  • Save ollyja/3634222c6bb0fa889f4aea03bce64aff to your computer and use it in GitHub Desktop.
Save ollyja/3634222c6bb0fa889f4aea03bce64aff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dump sql output to file in csv
select menu_name, stock_qty, total_sold from ti_menus where total_sold > 0 and subtract_stock >0 and stock_qty < 10 and menu_status > 0 INTO OUTFILE '/tmp/menus.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