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

1 row in set (0.00 sec)

• 
  mysql> select *from mahsulotlar;
  
• 
  +---------------+---------------------+---------------+---------------+---------------------------+
  
• 
  | Mahsulot_kodi | Nomi | Ulgurji_narxi | Chakana_Narxi | Tavsifi |
  
• 
  +---------------+---------------------+---------------+---------------+---------------------------+
  
• 
  | 202001 | Kiryuvish mashinasi | 5000000 | 4000000 | Toliq avtomatlashtirilgan |
  
• 
  | 202002 | Kiryuvish kukuni | 10000 | 8000 | Kristal kabi tozalik |
  
• 
  | 202003 | Zaytun yogi | 45000 | 38000 | Doglangan |
  
• 
  +---------------+---------------------+---------------+---------------+---------------------------+
  
• 
  3 rows in set (0.00 sec)
  

• 
  
  
• 
  Xaridorlar jadvali
  
• 
  
  

• 
  mysql> desc xaridorlar;
  
• 
  +-------------------+-------------+------+-----+---------+-------+
  
• 
  | Field | Type | Null | Key | Default | Extra |
  
• 
  +-------------------+-------------+------+-----+---------+-------+
  
• 
  | Xaridor_kodi | int | NO | PRI | NULL | |
  
• 
  | Telefon | varchar(15) | YES | | NULL | |
  
• 
  | Aloqa_Uchun_shaxs | varchar(25) | YES | | NULL | |
  
• 
  | Manzil | varchar(25) | YES | | NULL | |
  
• 
  +-------------------+-------------+------+-----+---------+-------+
  
• 
  4 rows in set (0.01 sec)
  
• 
  
  

• 
  mysql> select *from xaridorlar;
  
• 
  +--------------+-----------+-------------------+----------+
  
•