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 depozit = 'Kutubxona 1' UNION SELECT * FROM kitoblar WHERE depozit = 'Kutubxona 2';
+----+-----------------+--------------------+-------------+-------------+-----------+
| 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 kitoblar.*, author_info.* FROM kitoblar JOIN author_info ON kitoblar.muallifi = author_info.author_name;
ERROR 1146 (42S02): Table 'kutubxona.author_info' doesn't exist
mysql>



Xulosa:
Men ushbu amaliy mashg’ulotni bajarish davomida Where, and, or, not, like bilan ishlashni o’rgandim bu orqali malumotlarni bir biriga ulash va kritish va chiqarishni ham o’rganib oldim.