[sql] Products
Viewer
- -- Создаем таблицу Products
- CREATE TABLE IF NOT EXISTS Products (
- id INTEGER PRIMARY KEY,
- name TEXT,
- calories INTEGER
- );
- -- Добавляем столбец name, если его нет
- ALTER TABLE Products ADD COLUMN IF NOT EXISTS name TEXT;
- -- Вставляем данные о продуктах
- INSERT INTO Products (name, calories) VALUES ('Яблоко', 52);
- INSERT INTO Products (name, calories) VALUES ('Банан', 89);
- INSERT INTO Products (name, calories) VALUES ('Груша', 57);
- INSERT INTO Products (name, calories) VALUES ('Апельсин', 47);
- INSERT INTO Products (name, calories) VALUES ('Клубника', 32);
- INSERT INTO Products (name, calories) VALUES ('Морковь', 41);
- INSERT INTO Products (name, calories) VALUES ('Помидор', 18);
- INSERT INTO Products (name, calories) VALUES ('Огурец', 15);
- INSERT INTO Products (name, calories) VALUES ('Куриное филе', 165);
- INSERT INTO Products (name, calories) VALUES ('Гречка', 123);
- INSERT INTO Products (name, calories) VALUES ('Рис', 130);
- INSERT INTO Products (name, calories) VALUES ('Пшено', 123);
- INSERT INTO Products (name, calories) VALUES ('Макароны', 131);
- INSERT INTO Products (name, calories) VALUES ('Молоко', 42);
- INSERT INTO Products (name, calories) VALUES ('Кефир', 40);
Editor
You can edit this paste and save as new:
File Description
- Products
- Paste Code
- 23 Apr-2024
- 1.35 Kb
You can Share it: