Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO Paintings(name, painter, year, type, insuranceValue)
- VALUES('Ruskea aamu', 'Jarkko Kallio', 1920, 'oil', 1000)
- [21:03:31] Query finished in 0.068 second(s). Rows affected: 1
- OK
- INSERT INTO Museums(name, streetAddress, city)
- VALUES('Kansallismuseo', 'Kalliokatu 2', 'Helsinki');
- [21:10:23] Query finished in 0.068 second(s). Rows affected: 1
- Puhelinnumeron kohdalle jää oletusarvo ‘-’.
- OK
- INSERT INTO Owns(museumName, paintingName, painterName, start)
- VALUES('Kansallismuseo', 'Ruskea aamu', 'Jarkko Kallio', '2000-01-01')
- [21:13:43] Query finished in 0.069 second(s). Rows affected: 1
- Endin kohdalle jää NULL.
- OK
- INSERT INTO Museums(name, streetAddress, city, phone)
- VALUES('Nykytaiteen museo', 'Rantakatu 2', 'Tampere', '019-123123')
- [21:18:25] Query finished in 0.072 second(s). Rows affected: 1
- OK
- INSERT INTO Paintings(name, painter, year, type, insuranceValue)
- VALUES('Kivi', 'Dark Phuksi', '1800', 'watercolor', 100.5)
- [21:21:19] Query finished in 0.067 second(s). Rows affected: 1
- OK
- INSERT INTO Paintings(name, painter, year, type, insuranceValue)
- VALUES('Kallio', 'Dark Phuksi', '1800', 'fingerpaint', 100.5)
- [21:22:32] Error while executing SQL query on database 'test': CHECK constraint failed: Paintings
- Tyyppi ei ole tuettu, lisääminen ei onnistu.
- NOT OK
- INSERT INTO Paintings(name, painter, year, type, insuranceValue)
- VALUES('Kallio', 'Dark Phuksi', '2025', 'oil', 100.5)
- [21:23:31] Error while executing SQL query on database 'test': CHECK constraint failed: Paintings
- Vuosiluku on liian suuri, lisääminen ei onnistu.
- NOT OK
- INSERT INTO Museums(name, streetAddress, phone)
- VALUES('Laivamuseo', 'Kujakatu 12', '040125382')
- [21:25:53] Error while executing SQL query on database 'test': NOT NULL constraint failed: Museums.city
- Kaupungin kohdalle ei voi jäädä NULL, lisääminen ei onnistu.
- NOT OK
- INSERT INTO Owns(museumName, paintingName, painterName, start, end)
- VALUES('Testimuseo', 'Kivi', 'Dark Phuksi', '2001-01-01', '2002-01-01')
- [21:28:21] Error while executing SQL query on database 'test': FOREIGN KEY constraint failed
- Museota ‘Testimuseo’ ei löydy Museums taulusta, lisääminen ei onnistu.
- NOT OK
- INSERT INTO Owns(museumName, paintingName, painterName, start, end)
- VALUES('Kansallismuseo', 'Auringonlasku', 'Kalle', '2003-07-01', '2005-11-11')
- [21:30:00] Error while executing SQL query on database 'test': FOREIGN KEY constraint failed
- Maalausta nimeltä ‘Auringonlasku’ tai maalauksen tekijää nimeltä ‘Kalle’ ei löydy Paintings taulusta, lisääminen ei onnistu.
- NOT OK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement