SQLite export with column names

Let me take another crack at this. Dump column names and INSERT statements to a file. sqlite> .output test.data sqlite> pragma table_info(test); sqlite> .dump test sqlite> .quit $ cat test.data 0|test_id|int|0||1 1|test_name|varchar(35)|0||0 PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE test (test_id int primary key, test_name varchar(35)); INSERT INTO "test" VALUES(1,'Wibble'); INSERT

[manabou]

/CREATE TABLE/ ではじまる方を使う、mysqlに入れるには、tableの"を`にして、columnの"を取り除く