db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

NULL and quotes

Real files are messy. CSV mode handles quoted fields with commas and newlines, CRLF line ends and a byte order mark on its own. A marker such as N/A for missing values needs the NULL option.

task

Load members_dirty.csv (BOM, CRLF, quoted commas, N/A for NULL, one extra trailing column) into m_in.

hints