Database Administration
Export MySQL Query Results to a CSV File
SELECT ... INTO OUTFILE turns any query into a spreadsheet file, written by the server itself. Handle the quoting that keeps embedded commas safe,…
//
Tag: CSV
Database Administration
Import a CSV Into MySQL With LOAD DATA INFILE
Import a CSV into MySQL with LOAD DATA INFILE, the server's bulk loader. This tutorial maps a comma-separated file onto a table in one…
Programming
Read A CSV File In PHP
Read a CSV file in PHP with fgetcsv(), which splits each row into an array and keeps quoted fields containing commas intact. Pair it…