Mavzu: Ma’lumotlar bazasini loyixalash. Ma’lumotlar bazasi dasturlarini o’rnatish va sozlash. Moxiyat aloqa diogrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalash

| id | nomi | muallifi | depozit | ijara_narxi | janr |
+----+-----------------+--------------------+-------------+-------------+-----------+
| 1 | Sherlock Holmes | Arthur Conan Doyle | Kutubxona 1 | 5000 | Detective |
+----+-----------------+--------------------+-------------+-------------+-----------+
1 row in set (0.00 sec)


mysql> SELECT * FROM kitoblar WHERE ijara_narxi > 5000;
Empty set (0.00 sec)


mysql> SELECT * FROM kitoblar WHERE ijara_narxi > 4000;
+----+-----------------+--------------------+-------------+-------------+-----------+
| id | nomi | muallifi | depozit | ijara_narxi | janr |
+----+-----------------+--------------------+-------------+-------------+-----------+
| 1 | Sherlock Holmes | Arthur Conan Doyle | Kutubxona 1 | 5000 | Detective |
+----+-----------------+--------------------+-------------+-------------+-----------+
1 row in set (0.00 sec)


mysql> SELECT column1, column2 FROM kitoblar WHERE janr = 'Detective' AND depozit = 'Kutubxona 1';
ERROR 1054 (42S22): Unknown column 'column1' in 'field list'
mysql> SELECT * FROM kitoblar WHERE janr = 'Detective' OR janr = 'Adventure';
+----+-----------------+--------------------+-------------+-------------+-----------+
| id | nomi | muallifi | depozit | ijara_narxi | janr |
+----+-----------------+--------------------+-------------+-------------+-----------+
| 1 | Sherlock Holmes | Arthur Conan Doyle | Kutubxona 1 | 5000 | Detective |
+----+-----------------+--------------------+-------------+-------------+-----------+
1 row in set (0.00 sec)


mysql> SELECT * FROM kitoblar WHERE NOT janr = 'Romance';
+----+-----------------+--------------------+-------------+-------------+-----------+