/
eb
/
python_learn
Обзор
Документация
Войти
/
eb
/
python_learn
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
sqlite/sql_syntax_basics.sql
37 строк
1 KB
EvgeniyBudaev
SQLite Редактирование и удаление данных
27 фев 2021, 08:19
27 фев 2021, 08:19
c5d7a42
Код
Авторство
О чём код?
CREATE TABLE students ( first_name TEXT, last_name TEXT, age INTEGER ); CREATE TABLE employees ( first_name TEXT, last_name TEXT, age INTEGER ); -- Create INSERT INTO students(first_name, last_name, age) VALUES ("Jack", "White", "18"); INSERT INTO students(first_name, last_name, age) VALUES ("Jim", "Hopkins", "32"); INSERT INTO employees(first_name, last_name, age) VALUES ("Jane", "Black", "20"); -- Read SELECT * FROM students; SELECT first_name FROM students; SELECT * FROM employees; SELECT first_name FROM students WHERE first_name = "Jack"; SELECT first_name FROM students WHERE first_name IS "Jack"; SELECT last_name FROM students WHERE last_name IS NOT "White"; SELECT last_name, age FROM students WHERE last_name IS NOT "White" AND age IS NOT 17; SELECT last_name, age FROM students WHERE age < 18; SELECT first_name FROM students WHERE first_name LIKE "Ja%"; SELECT * FROM students WHERE first_name LIKE "%ck" OR last_name LIKE "%ck"; SELECT * FROM students WHERE first_name LIKE "%an%" -- Update UPDATE students SET first_name="Jimmi" WHERE first_name="Jim" UPDATE students SET age=19 WHERE first_name="Jim" OR last_name="Hopkins" -- Delete DROP TABLE table_name; DELETE FROM students WHERE age=20