CSV เป็น SQL INSERT

วิธีใช้เครื่องมือนี้

1. 1

   Type the destination table name into the top field (it is dropped into the generated INSERT exactly as typed).

2. 2

   Paste your CSV into the text box, keeping the header row first so its names become the column list.

3. 3

   Read the INSERT statements that appear below as you type, with one statement per data row.

4. 4

   Select the generated SQL and copy it into your database client or migration script to run it.

CSV เป็น SQL INSERT คืออะไร?

กรณีการใช้งานทั่วไป

• Seeding a few rows of test or fixture data into a local development database without writing the INSERTs by hand.

• Converting a small spreadsheet export of lookup values (statuses, categories, country codes) into a migration script.

• Drafting INSERT statements for a quick demo or tutorial where the data is short and contains no commas inside fields.

• Reshaping a handful of rows copied from a CSV file into SQL you can paste into a query console.

• Generating a starting point for a data-load script that you will then hand-edit to add NULLs or fix column types.

• Teaching or learning SQL INSERT syntax by watching how column lists and quoted values are assembled from rows.

คำถามที่พบบ่อย