Extract inventory rows from SQL INSERT statements
Review SQL seed records in a spreadsheet without connecting to a database.
Set up the example
Convert the INSERT statements in the sample and compare the CSV header with the SQL column list.
Check the result
The output should contain three rows of values. The quoted SQL text Pens, blue should occupy one CSV field.
Run this task
Use your own file or download the practice input below. The checks on this page describe the practice result.
Continue with a related task
- Extract SQL INSERT values into a JSON fixture
Read INSERT values into a table → Use the column names as JSON keys
- Make an inventory workbook from a quoted CSV
- Generate SQL INSERT statements from JSON stock records