https://www.runoob.com/sqlite/sqlite-create-table.html
CREATE TABLE "person" (
"id" INTEGER NOT NULL UNIQUE,
"name" TEXT NOT NULL,
"height" REAL,
"weight" REAL,
"bmi" REAL,
PRIMARY KEY("id" AUTOINCREMENT)
);
INSERT into person (name, weight, height) VALUES("Dvid", 70, 1.75);
INSERT into person (name, weight, height) VALUES("Candy", 50, 1.65);
INSERT into person (name, weight, height) VALUES("may", 60, 1.58);
SELECT * from person where weight>60;
UPDATE person set weight=52 where name="Candy";
DELETE FROM person where name="Candy";
#刪掉整個Table
DROP TABLE person