Toshkent axborot texnalogiyalari unversiteti Farg’ona filiali Dasturiy injinering va raqamli iqtisodiyot

| Xaridor_kodi | Telefon | Aloqa_Uchun_shaxs | Manzil |

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

| 303001 | 999999999 | Samandar | Fargona |

| 303002 | 998888888 | Diyora | Namangan |

| 303003 | 997777777 | Maqsud | Toshkent |

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

3 rows in set (0.00 sec)

Bitimlar

• 
  mysql> desc bitimlar;
  
• 
  +------------------+-------------+------+-----+---------+-------+
  
• 
  | Field | Type | Null | Key | Default | Extra |
  
• 
  +------------------+-------------+------+-----+---------+-------+
  
• 
  | Tranzaksiya_kodi | int | YES | UNI | NULL | |
  
• 
  | Bitim_sanasi | date | YES | | NULL | |
  
• 
  | Mahsulot_kodi | int | YES | UNI | NULL | |
  
• 
  | Miqdori | varchar(20) | YES | | NULL | |
  
• 
  | Xaridor_kodi | int | YES | | NULL | |
  
• 
  | Ulgurji_atribut | varchar(30) | YES | | NULL | |
  
• 
  +------------------+-------------+------+-----+---------+-------+
  
• 
  6 rows in set (0.00 sec)
  
• 
  
  

• 
  mysql> select *from bitimlar;
  
• 
  +------------------+--------------+---------------+---------+--------------+------------------+
  
• 
  | Tranzaksiya_kodi | Bitim_sanasi | Mahsulot_kodi | Miqdori | Xaridor_kodi | Ulgurji_atribut |
  
• 
  +------------------+--------------+---------------+---------+--------------+------------------+
  
• 
  | 101001 | 2023-10-10 | 202001 | 1 dona | 303001 | Oila uchun zarur |
  
•