/
NeonBite
/
java-course-1.0-lab9
Обзор
Документация
Войти
/
NeonBite
/
java-course-1.0-lab9
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
music-create.sql
28 строк
797 B
NeonBite
initial commit
17 ноя 2025, 04:03
17 ноя 2025, 04:03
c275b57
Код
Авторство
О чём код?
create table if not exists study.music ( id int primary key, name text not null ); INSERT INTO study.music (id, name) select * from (VALUES (1, 'Bohemian Rhapsody'), (2, 'Stairway to Heaven'), (3, 'Imagine'), (4, 'Sweet Child O Mine'), (5, 'Hey Jude'), (6, 'Hotel California'), (7, 'Billie Jean'), (8, 'Wonderwall'), (9, 'Smells Like Teen Spirit'), (10, 'Let It Be'), (11, 'I Want It All'), (12, 'November Rain'), (13, 'Losing My Religion'), (14, 'One'), (15, 'With or Without You'), (16, 'Sweet Caroline'), (17, 'Yesterday'), (18, 'Dont Stop Believin'), (19, 'Crazy Train'), (20, 'Always')) as new_data WHERE NOT EXISTS (SELECT 1 FROM study.music);