Enter password: Welcome to the Mysql monitor. Commands end with; or \g


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


Download 1.38 Mb.
bet3/4
Sana16.06.2023
Hajmi1.38 Mb.
#1490311
1   2   3   4
Bog'liq
restaran

+-------+--------+--------+-----------+
| 1 | 15000 | zor | gosht |
| 2 | 150000 | zor | yog |
| 3 | 5000 | yahshi | un |
| 4 | 5000 | yahshi | chuchvara |
| 5 | 40000 | yahshi | tuhum |
+-------+--------+--------+-----------+
5 rows in set (0.00 sec)
mysql> insert into tranzaksiya_xisoboti
-> values(1,'2022-9-11','222','4','manzili aniq yetkazilsin','2022-12-11'),
-> (2,'2022-9-11','224','5','manzili aniq yetkazilsin','2022-12-11'),
-> (3,'2022-9-11','225','3','manzili aniq yetkazilsin','2022-12-11'),
-> (4,'2022-9-11','226','2','manzili aniq yetkazilsin','2022-12-11'),
-> (5,'2022-9-11','227','6','manzili aniq yetkazilsin','2022-12-11');
Query OK, 5 rows affected (0.01 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> select * from tranzaksiya_xisoboti;
'>+-------+------------------+-----------+----------+----------------------------+--------------+'>+-------+------------------+-----------+----------+----------------------------+--------------+
| tx_id | tranzaksiya_data | ekipaj_id | mijoz_id | muyurtma_identifikatsiyasi | hisobot_sana |
+-------+------------------+-----------+----------+----------------------------+--------------+
| 1 | 2022-09-11 | 222 | 4 | manzili aniq yetkazilsin | 2022-12-11 |
| 2 | 2022-09-11 | 224 | 5 | manzili aniq yetkazilsin | 2022-12-11 |
| 3 | 2022-09-11 | 225 | 3 | manzili aniq yetkazilsin | 2022-12-11 |
| 4 | 2022-09-11 | 226 | 2 | manzili aniq yetkazilsin | 2022-12-11 |
| 5 | 2022-09-11 | 227 | 6 | manzili aniq yetkazilsin | 2022-12-11 |
+-------+------------------+-----------+----------+----------------------------+--------------+
5 rows in set (0.00 sec)

mysql>
mysql> insert into yetkazib_berish
-> values(1,'2022-12-11','222'),
-> (2,'2022-12-11','223'),

Download 1.38 Mb.

Do'stlaringiz bilan baham:
1   2   3   4




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling