67 lines
1.3 KiB
SQL
67 lines
1.3 KiB
SQL
-- Use INSERT to add a record.
|
|
INSERT INTO
|
|
enclosures (biome, name, area)
|
|
VALUES (
|
|
'Arktida',
|
|
'Ledové království',
|
|
2500
|
|
);
|
|
|
|
SELECT * FROM enclosures;
|
|
|
|
INSERT INTO
|
|
enclosures (name, area, biome)
|
|
VALUES (
|
|
'Savanvoá pláň',
|
|
1700,
|
|
'Savana'
|
|
),
|
|
(
|
|
'Křišťálová laguna',
|
|
900,
|
|
'Tropické vody'
|
|
),
|
|
(
|
|
'Zelený divoký les',
|
|
750,
|
|
'Mírný les'
|
|
);
|
|
|
|
-- Increase every enclosure area by 100 square meters.
|
|
UPDATE enclosures SET area = area + 100;
|
|
|
|
SELECT * FROM enclosures;
|
|
|
|
-- Increase smaller enclosure areas by 50 square meters.
|
|
|
|
UPDATE enclosures SET area = area + 50 WHERE area < 1500;
|
|
|
|
-- Update multiple columns in one statement.
|
|
UPDATE enclosures SET biome = 'Oceán', area = area + 25 WHERE id = 3;
|
|
|
|
-- Delete a selected record.
|
|
|
|
DELETE FROM enclosures WHERE id = 3;
|
|
|
|
SELECT * FROM enclosures;
|
|
|
|
INSERT INTO
|
|
animals (name, adoption_date, note)
|
|
VALUES (
|
|
'hroch',
|
|
'2026-10-25',
|
|
'hrošík Igor'
|
|
);
|
|
|
|
INSERT INTO
|
|
animals (name, adoption_date, note)
|
|
VALUES ('vlk', NOW(), 'pozor kouše');
|
|
|
|
INSERT INTO
|
|
animals (name, adoption_date, note)
|
|
VALUES ('vlk', NOW(), 'pozor kouše');
|
|
|
|
SELECT * FROM animals;
|
|
|
|
SELECT * FROM animals_keepers;
|