CREATE TABLE `students`
(
`id` INTEGER PRIMARY KEY AUTO_INCREMENT,
`name` TEXT NOT NULL,
`age` INTEGER NOT NULL
);
-- добавление
INSERT INTO `students`
(`name`, `age`)
VALUES
('Anna', 15),
('Ryan', 16), ('Joanna', 16), ('Danil', 16),
('Johan', 17),
('Petia', 18),
('Slava', 19),
('Osipov', 21),
('Nastya', 22),
('Igor', 23), ('Polina', 23), ('Katia', 23),
('Rislan', 24), ('Liza', 24), ('Dasha', 24),
('Adam', 25), ('Maksim', 25), ('Ivan', 25), ('Egor', 25), ('Pavel', 25),
('Lev', 26), ('Kirill', 26), ('Vadim', 26), ('Victor', 26), ('Leonid', 26);
-- удаление
-- DELETE FROM `students` WHERE `age` IN (16, 25, 26);
-- выборка
-- SELECT * FROM `students` WHERE `age` = 23;
-- сортировки
SELECT * FROM `students` ORDER BY `name` ASC;
-- SELECT * FROM `students`;
To embed this project on your website, copy the following code and paste it into your website's HTML: