blog - create a new database in sqlite

sqlite_create_db.sql

.open pizzas.db

-- drop table pizza;
    
CREATE TABLE pizza (
    id int, 
    name text, 
    calorie int, 
    price real
);

INSERT INTO pizza VALUES
    (1, "Hawaiian", 500, 25.75),
    (2, "Chicken", 480, 24.50),
    (3, "Spicy", 250, 22.35),
    (4, "BBQ", 390, 26.25),
    (5, "Supreme Cheese", 680, 32.50);

.mode column 
.header on

SELECT * FROM pizza;