SQLite3: Importing a CSV File #shorts

#shorts , #sqlite3, #superstore
How-to import a csv file into SQLite3 #shorts

#Haiku Playlist:
* Haiku OS Install (BeOS Clone):
* Haiku OS Update (and failed Pandas installed):
* Haiku OS: Installing Emacs and Emacs's Evil Mode (vim):
* Haiku OS: Installing ed editor, and using Awk to print Hello World!:
* Haiku OS: Emacs As A Python IDE (part 1):
* Haiku OS: Emacs a Python IDE works:
* Haiku Data Analytics @ The Command Line(1) :

[CaribouDataScience]

Here is the code:

# Importing CSV Files!!

CREATE TABLE superstore (
"Row ID" INTEGER,
"Order ID" TEXT,
"Order Date" TEXT,
"Ship Date" TEXT,
"Ship Mode" TEXT,
"Customer ID" TEXT,
"Customer Name" TEXT,
"Segment" TEXT,
"Country" TEXT,
"City" TEXT,
"State" TEXT,
"Postal Code" INTEGER,
"Region" TEXT,
"Product ID" TEXT,
"Category" TEXT,
"Sub-Category" TEXT,
"Product Name" TEXT,
"Sales" REAL
);
.mode csv
.headers on
.import superstore.csv superstore
PRAGMA table_info(superstore);
SELECT count(*) FROM superstore;