Guruh 650-21
Mavlonov Xamdam
2-dedline
1. Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha AND, OR, NOT operatorlaridan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi kerak. mysql> select*from xaridorlar; +----------+--------------+----------+-------------+---------+-----------+ | ism | familaya | ota_ismi | manzil | shahar | telefoni | +----------+--------------+----------+-------------+---------+-----------+ | Aziza | Ahmedova | Akmaljon | Fergana | Qoqon | 901429851 | | Arslon | Asliddinov | Akbarjon | Fergana | Qoqon | 911423151 | | Behzod | Bakirov | Behruz | Qashqadaryo | Kitob | 931449872 | +----------+--------------+----------+-------------+---------+-----------+ 5 rows in set (0.00 sec) mysql> select*from xaridorlar where familaya='Bakirov' and shahar='Kitob'; +--------+----------+----------+-------------+--------+-----------+ | ism | familaya | ota_ismi | manzil | shahar | telefoni | +--------+----------+----------+-------------+--------+-----------+ | Behzod | Bakirov | Behruz | Qashqadaryo | Kitob | 991827319 | +--------+----------+----------+-------------+--------+-----------+ 1 row in set (0.00 sec) mysql> select*from xaridorlar where familaya='Bakirov' or shahar='Kitob'; +----------+----------+----------+-------------+--------+-----------+ |
