Добавил:
Katynska
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:Разные СУБД / Лаба 5 / БД SQL / Запрос 5
.sql INSERT INTO Product (maker, model, type)VALUES
('Amdahl', 1611, 'pc' ),
('Amdahl', 1612, 'pc'),
('Amdahl', 1613, 'pc'),
('Amdahl', 1511, 'laptop'),
('Amdahl', 1512, 'laptop'),
('Amdahl', 1513, 'laptop'),
('blackСoffin', 1621, 'pc'),
('blackСoffin', 1622, 'pc'),
('blackСoffin', 1623, 'pc'),
('blackСoffin', 1521, 'laptop'),
('CellAndMachine', 1631, 'pc'),
('DriverSF', 1641, 'pc'),
('DriverSF', 1642, 'pc'),
('DriverSF', 1643, 'pc'),
('DriverSF', 1841, 'printer'),
('DriverSF', 1842, 'printer'),
('Eureka', 1651, 'pc'),
('Eureka', 1652, 'pc'),
('Eureka', 1653, 'pc'),
('Eureka', 1551, 'laptop'),
('Eureka', 1552, 'laptop'),
('Eureka', 1553, 'laptop'),
('Eureka', 1851, 'printer'),
('Eureka', 1852, 'printer'),
('Eureka', 1853, 'printer'),
('Fiji', 1561, 'laptop'),
('Fiji', 1562, 'laptop'),
('GGTop', 1571, 'laptop'),
('HellMachine', 6661, 'printer'),
('HellMachine', 6662, 'printer');
INSERT INTO Product (maker)VALUES
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl'),
('blackСoffin'),
('blackСoffin'),
('blackСoffin'),
('blackСoffin')
('Amdahl', 1611, 'pc' ),
('Amdahl', 1612, 'pc'),
('Amdahl', 1613, 'pc'),
('Amdahl', 1511, 'laptop'),
('Amdahl', 1512, 'laptop'),
('Amdahl', 1513, 'laptop'),
('blackСoffin', 1621, 'pc'),
('blackСoffin', 1622, 'pc'),
('blackСoffin', 1623, 'pc'),
('blackСoffin', 1521, 'laptop'),
('CellAndMachine', 1631, 'pc'),
('DriverSF', 1641, 'pc'),
('DriverSF', 1642, 'pc'),
('DriverSF', 1643, 'pc'),
('DriverSF', 1841, 'printer'),
('DriverSF', 1842, 'printer'),
('Eureka', 1651, 'pc'),
('Eureka', 1652, 'pc'),
('Eureka', 1653, 'pc'),
('Eureka', 1551, 'laptop'),
('Eureka', 1552, 'laptop'),
('Eureka', 1553, 'laptop'),
('Eureka', 1851, 'printer'),
('Eureka', 1852, 'printer'),
('Eureka', 1853, 'printer'),
('Fiji', 1561, 'laptop'),
('Fiji', 1562, 'laptop'),
('GGTop', 1571, 'laptop'),
('HellMachine', 6661, 'printer'),
('HellMachine', 6662, 'printer');
INSERT INTO Product (maker)VALUES
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl' ),
('Amdahl'),
('blackСoffin'),
('blackСoffin'),
('blackСoffin'),
('blackСoffin')
Соседние файлы в папке БД SQL