Asadbek Sotqinboyev Mavzu : sql tilida jadvallarni yaratish, o’zgartirish va o’chirish. Ishdan maqsad: Berilgan predmet sohasi uchun sql tilida jadvallarni yaratish, o’zgartirish va o’chirish bo`yicha ko`nikmaga EGA bo`lish

| id | mah_t_id | mah_nomi | chiqar_sana | miqdori | narxi |

+----+----------+-----------+-------------+---------+--------+

| 1 | 3 | ayiqcha | 12/21/2020 | 110 | 120000 |

| 2 | 4 | kompyut | 01/12/2019 | 200 | 600000 |

| 3 | 4 | sha_kom | 08/12/2018 | 150 | 750000 |

| 4 | 1 | velosiped | 12/15/2019 | 300 | 110000 |

| 5 | 1 | sketboa | 04/15/2017 | 122 | 300000 |

| 6 | 2 | gadget | 07/10/2020 | 120 | 320000 |

+----+----------+-----------+-------------+---------+--------+

6 rows in set (0.06 sec)

mysql> select*from yetkazuvchi_mashina;

+----+-------------+--------------+-------------+-----------+----------------+

| id | mahsulot_id | mashina_nomi | yet_miqdori | yet_narxi | mashina_holati |

+----+-------------+--------------+-------------+-----------+----------------+

| 1 | 3 | MAN | 90 | 300000 | NULL |

| 2 | 4 | ISUZU | 150 | 380000 | NULL |

| 3 | 1 | ISUZU | 100 | 250000 | NULL |

| 4 | 2 | MAN | 250 | 200000 | NULL |

| 5 | 5 | MAN | 120 | 340000 | NULL |

| 6 | 6 | ISUZU | 110 | 150000 | NULL |

+----+-------------+--------------+-------------+-----------+----------------+

Bu sqldagi shaxsiy ma’lumotlari ma’lumotlarni men ularni select yordamida chiqardim;