Planet name,Distance (AU),Mass
Mercury,0.4,0.055
Venus,0.7,0.815
Earth,1,1
Mars,1.5,0.107
Ceres,2.77,0.00015
Jupiter,5.2,318
Saturn,9.5,95
Uranus,19.6,14
Neptune,30,17
Pluto,39,0.00218
Charon,39,0.000254
.mode batch
.import --csv -v examples/planets.csv planets
SELECT '----------';
.schema
SELECT '----------';
SELECT * FROM planets;
SELECT "Distance (AU)" FROM planets;
$ sqlite3 < examples/import-planets.sql
Column separator ",", row separator "\n"
CREATE TABLE "main"."planets"(
"Planet name" ANY, "Distance (AU)" ANY, "Mass" ANY)
Added 11 rows with 0 errors using 12 lines of input
----------
CREATE TABLE "planets"(
"Planet name" ANY, "Distance (AU)" ANY, "Mass" ANY);
----------
Mercury|0.4|0.055
Venus|0.7|0.815
Earth|1|1
Mars|1.5|0.107
Ceres|2.77|0.00015
Jupiter|5.2|318
Saturn|9.5|95
Uranus|19.6|14
Neptune|30|17
Pluto|39|0.00218
Charon|39|0.000254
0.4
0.7
1
1.5
2.77
5.2
9.5
19.6
30
39
39