Amaliy ish-4-5-6


mysql> select*from sportzal where id between 2 and 4


Download 1.3 Mb.
Pdf ko'rish
bet3/5
Sana24.11.2022
Hajmi1.3 Mb.
#930041
1   2   3   4   5
Bog'liq
4-практика№4, Algebra va matematik analiz fanidan lug at (R.Yarqulov, M.Barakayeva), Маъмуралиев Авазбек 1, Мустакил иш, Мустакил иш, Амалиёт-15, fulltext, sss, civil proj advt, civil proj advt, problem, integral tenglamalarni yechish metodlari — копия, VLSI Implementation of Cellular Neural N, Sayt nomi, Sayt nomi
 
mysql> select*from sportzal where id between 2 and 4; 
+------+-----------+-----------+--------------+ 
| id | nomi | sportturi | qurilgansana | 
+------+-----------+-----------+--------------+ 
| 3 | humoarena | hokkey | 2010-10-20 | 
+------+-----------+-----------+--------------+ 
1 row in set (0.00 sec) 
 
mysql> select max(id)'sana' from sportzal
+------+ 
| sana | 
+------+ 
| 3 | 
+------+ 
1 row in set (0.00 sec) 
 
mysql> select sum(id)'yigindi'from sportzal; 
+---------+ 
| yigindi | 
+---------+ 
| 4 | 


+---------+ 
1 row in set (0.00 sec) 
 
mysql> select mid(nomi,1,1)as 'boshharf',nomi from sportzal; 
+----------+-------------------+ 
| boshharf | nomi | 
+----------+-------------------+ 
| b | bunyodkorstadioni | 
| h | humoarena | 
+----------+-------------------+ 
2 rows in set (0.00 sec) 
 
mysql> alter table sportzal add harajat int
Query OK, 0 rows affected (0.02 sec) 
Records: 0 Duplicates: 0 Warnings: 0 
 
mysql> select*from sportzal; 
+------+-------------------+-----------+--------------+---------+ 
| id | nomi | sportturi | qurilgansana | harajat | 
+------+-------------------+-----------+--------------+---------+ 
| 1 | bunyodkorstadioni | futbol | 2010-10-20 | NULL | 
| 3 | humoarena | hokkey | 2010-10-20 | NULL | 
+------+-------------------+-----------+--------------+---------+ 
2 rows in set (0.00 sec) 

Download 1.3 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5




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