· 8 years ago · Apr 20, 2018, 07:48 AM
1-- CREATE DATABASE u_ti312
2USE u_ti312;
3DROP TABLE IF EXISTS tb;
4CREATE TABLE tb
5(
6 id INT KEY AUTO_INCREMENT,
7 data DATE NOT NULL,
8 waga FLOAT NOT NULL
9);
10-- ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_polish_ci;
11INSERT INTO tb(id, data, waga) VALUES
12(1, '2018-09-22', 99),
13(2, '2015-06-15', 89),
14(3, '2014-08-08', 79);
15SELECT * FROM tb;
16
17DROP TABLE tb;