Guruh: 610-20 Tayyorladi: Ubaydullayeva Dilshoda Qabul qildi: A. Dilshodov, M. Burxonova Mavzu: Supermarket axborot tizimlari

Guruh:610-20
Tayyorladi:Ubaydullayeva Dilshoda
Qabul qildi: A.Dilshodov, M.Burxonova
Mavzu: Supermarket axborot tizimlari
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.26 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

mysql> show tables from supermarket_AT; Empty set (0.00 sec)

mysql> show databases;

mysql> create table bolim_jadvali

-> (bolim_nomi varchar(30),
-> rastalar_soni int(25),
-> sotuvchilar_soni int(28),
-> zal_soni int(30));
Query OK, 0 rows affected, 3 warnings (1.36 sec)

mysql> desc bolim_jadvali;

mysql> create table xodimlar_jadvali

-> (familiyasi varchar(30),
-> ismi varchar(28),
-> otasining_ismi varchar(29),
-> bolimi varchar(45),
-> tugilgan_yili year,

-> ishga_kirgan_yili year,

-> ish_staji varchar(35),
-> lavozimi varchar(40),
-> jinsi varchar(40),
-> manzili varchar(45),
-> shahri varchar(40),
-> telefon int(50));
mysql> create table lavozim_jadvali
-> (lavozimlar_nomi varchar(40),
-> shtat_birligidagi_summa int(35));
Query OK, 0 rows affected, 3 warnings (1.36 sec)

mysql> create lavozimlar_jadvali

-> (lavozim_nomi varchar(40),
-> shtat_birligidagi_summa varchar(45))
Query OK, 0 rows affected, 1 warning (1.32 sec)

mysql> create table tovarl_jadvali

-> (tovar_nomi varchar(50),
-> bolimi varchar(45),
-> ishlab_chiqarilgan_mamlakat varchar(55), -> saqlash_sharoiti varchar(30), -> saqlash_muddati varchar(45));
Query OK, 0 rows affected (0.81 sec)

mysql> create table tovar_savdolari

-> (sotuvchi varchar(30),
-> tovar varchar(60),
-> sanasi int(45),
-> vaqti int(40),
-> miqdori varchar(28),
-> narxi int(35),
-> summasi int(40));
Query OK, 0 rows affected, 4 warnings (0.44 sec)