Telekomunikatsiya texnologiyalari



Download 21,26 Kb.
Sana07.12.2022
Hajmi21,26 Kb.
#880734
Bog'liq
MB2 ish CHF


Muhammad-Al Xorazmiy nomidagi


Toshkent axbarot texnologiyalar universitetining
“Telekomunikatsiya texnologiyalari” fakultetining
414-21-guruh talabasi Choriyev Fazliddinning Malumotlar bazasi fanidan bajargan
2-shaxsiy topshirig’i

Enter password: ******


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, 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;


+--------------------+
| Database |
+--------------------+
| hokimyat |
| gun |
| information_schema |
| internet_magazin |
| man |
| mustaqil |
| mysql |
| oquv |
| oquvci |
| performance_schema |
| student |
| sys |
| vakzal |
+--------------------+
13 rows in set (0.09 sec)

mysql> use center;


Database changed
mysql> select*from center;
ERROR 1146 (42S02): Table 'center.center' doesn't exist
mysql> create database hokimyat;
Query OK, 1 row affected (0.23 sec)

mysql> use hokimyat;


Database changed
mysql> create table hokim(id int, ismi varchar(20), lavozimi varchar(20));
Query OK, 0 rows affected (0.87 sec)

mysql> insert into xurmat values(1,"FAZLIDDIN","HOKIM"),(2,"AZIZBEK","HOKIMYORDAMCHISI"),(3,"MURODJON","ORINBOSAR");


Query OK, 3 rows affected (0.20 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> SELECT*from hokim;


+------+-----------+-------------------+
| id | ismi | lavozimi |
+------+-----------+-------------------+
| 1 | FAZLIDDIN | HOKIM |
| 2 | AZIZBEK | HOKIMYORDAMCHISI |
| 3 | MURODJON | ORINBOSAR |
+------+-----------+-------------------+
3 rows in set (0.00 sec)

mysql> alter table hokim add oyligi date;


Query OK, 0 rows affected (0.41 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> update hokim set oyligi=10000000 where id=1;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2022 where id=1' at line 1
mysql> update hokim set oyligi="10000000" where id=1;
Query OK, 1 row affected, 1 warning (0.42 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> select*from hokim;


+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 2 | AZIZBEK | HOKIMYORDAMCHISI | NULL |
| 3 | MURODJON | ORINBOSAR | NULL |
+------+-----------+-------------------+------------+
3 rows in set (0.00 sec)
mysql> update hokim set oyligi=5000000 where id=2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2022 where id=2' at line 1
mysql> mysql> update hokim set oyligi="5000000" where id=2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> update xurmat set sana="20.11.2022" where id=2' at line 1
mysql> mysql> update hokim set oyligi="5000000 " where id=2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> update hokim set oyligi="5000000" where id=2' at line 1
mysql> update hokim set oyligi="7000000" where id=3;
Query OK, 1 row affected, 1 warning (0.17 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> update hokim set oyligi="5000000" where id=2;


Query OK, 1 row affected, 1 warning (0.18 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> swlwct * from hokim;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'swlwct * from xurmat' at line 1
mysql> select * from hokim;
+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 2 | AZIZBEK | HOKIMYORDAMCHISI | 5000000 |
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+-----------+-------------------+------------+
3 rows in set (0.00 sec)

mysql> select id, ismi from hokim where id>1;


+------+----------+
| id | ismi |
+------+----------+
| 2 | AZIZBEK |
| 3 | MURODJON |
+------+----------+
2 rows in set (0.00 sec)

mysql> select *from hokim;


+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 2 | AZIZBEK | HOKIMYORDAMCHISI | 5000000 |
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+-----------+-------------------+------------+
3 rows in set (0.00 sec)

mysql> delete from hokim where id=2;


Query OK, 1 row affected (0.21 sec)

mysql> select * from hokim;


+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+-----------+-------------------+------------+
2 rows in set (0.00 sec)

mysql> Select *from hokim where id between 2 and 4;


+------+----------+-----------+------------+
| id | ismi | lavozimi | oyligi |
+------+----------+-----------+------------+
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+----------+-----------+------------+
1 row in set (0.00 sec)
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.28 MySQL Community Server - GPL

Copyright (c) 2000, 2022, 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;


+--------------------+
| Database |
+--------------------+
| hokimyat |
| gun |
| information_schema |
| internet_magazin |
| man |
| mustaqil |
| mysql |
| oquv |
| oquvci |
| performance_schema |
| student |
| sys |
| vakzal |
+--------------------+
14 rows in set (0.38 sec)

mysql> use mustaqil;


Database changed
mysql> select * from xurmat;
ERROR 1146 (42S02): Table 'mustaqil.xurmat' doesn't exist
mysql> insert imto xurmat values(4,"Xusanjon","matematik");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xurmat values(4,"Xusanjon","matematik")' at line 1
mysql> sshow databases;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sshow databases' at line 1
mysql> select*from xurmat;
ERROR 1146 (42S02): Table 'mustaqil.xurmat' doesn't exist
mysql> use hokimyat;
Database changed
mysql> select* from hokim;
+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+-----------+-------------------+------------+
2 rows in set (0.19 sec)

mysql> select*from hokim;


+------+-----------+-------------------+------------+
| id | ismi | lavozimi | oyligi |
+------+-----------+-------------------+------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 |
| 3 | MURODJON | ORINBOSAR | 7000000 |
+------+-----------+-------------------+------------+
2 rows in set (0.00 sec)

mysql> select max(id) as oyligi;


ERROR 1054 (42S22): Unknown column 'id' in 'field list'
mysql> select max(id) 'oyligi' from hokim;
+------+
| oyligi |
+------+
| 1 |
+------+
1 row in set (0.02 sec)

mysql> select sum(id) 'ismi' from hokim;


+------+
| ismi |
+------+
| 4 |
+------+
1 row in set (0.00 sec)

mysql> select mid(ismi,1,1) as lavozimi ismi from hokim;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ismi from hokim' at line 1
mysql> select mid(ismi ,1,1) as ' lavozimi ', ismi from hokim;
+------------+-----------+
| lavozimi | ismi |
+------------+-----------+
| F | FAZLIDDIN |
| M | MURODJON |
+------------+-----------+
2 rows in set, 1 warning (0.00 sec)

mysql> alter table hokim add ish_tajribasi int ;


Query OK, 0 rows affected (0.68 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select* from hokim;


+------+-----------+-------------------+------------+-------------+
| id | ismi | lavozimi | oyligi | ish_tajribasi |
+------+-----------+-------------------+------------+-------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 | NULL |
| 3 | MURODJON | ORINBOSAR | 7000000 | NULL |
+------+-----------+-------------------+------------+-------------+
2 rows in set (0.00 sec)

mysql> update hokim set ish_tajribasi=8 where id=1;


Query OK, 1 row affected (0.19 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update hokim set ish_tajribasi=5 where id =2;


Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql> update hokim set ish_tajribasi=7 where id=3;


Query OK, 1 row affected (0.17 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select *from hokim;


+------+-----------+-------------------+------------+-------------+
| id | ismi | lavozimi | oyligi | ish_tajribasi |
+------+-----------+-------------------+------------+-------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 | 8 |
| 3 | MURODJON | ORINBOSAR | 7000000| 7 |
+------+-----------+-------------------+------------+-------------+
2 rows in set (0.00 sec)

mysql> select id ,sum(ish_tajribasi) as' ish_tajribasi' from hokim group by id;


+------+-------------+
| id | |
+------+-------------+
| 1 | 8 |
| 3 | 7 |
+------+-------------+
2 rows in set, 1 warning (0.04 sec)

mysql> select * from hokim order by lavozimi;


+------+-----------+-------------------+------------+-------------+
| id | ismi | lavozimi | oyligi | ish_tajribasi |
+------+-----------+-------------------+------------+-------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 | 8 |
| 3 | MURODJON | ORINBOSAR | 7000000 | 7 |
+------+-----------+-------------------+------------+-------------+
2 rows in set (0.10 sec)

mysql> select * from hokim having ish_tajribasi >7;


+------+----------+-----------+------------+-------------+
| id | ismi | lavozimi | oyligi | ish_tajribasi |
+------+----------+-----------+------------+-------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 | 8 |
+------+----------+-----------+------------+-------------+
1 row in set (0.14 sec)

mysql> select *from hokim ;


+------+-----------+-------------------+------------+-------------+
| id | ismi | lavozimi | oyligi | ish_tajribasi |
+------+-----------+-------------------+------------+-------------+
| 1 | FAZLIDDIN | HOKIM | 10000000 | 8 |
| 3 | MURODJON | ORINBOSAR | 7000000 | 7 |
+------+-----------+-------------------+------------+-------------+
2 rows in set (0.00 sec)


mysql>
Download 21,26 Kb.

Do'stlaringiz bilan baham:




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

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish