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

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.51-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

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

mysql> show databases;
+--------------------------------------+
| Database |
+--------------------------------------+
| information_schema |
| kafedra |
| kafedra_talabalarining_ozlashtirishi |
| kutubxona |
| mysql |
| ozlashtirish_korsatgichi |
| talaba_ozlashtirish |
| talabalar_ozlash |
| talabalar_ozlashtirish |
| temiryol_stansiyasi |
| test |
+--------------------------------------+
11 rows in set (0.00 sec)

mysql> use kutubxona;

Database changed
mysql> show tables;
+---------------------+
| Tables_in_kutubxona |
+---------------------+
| adabiyot_turi |
| fondni_toldirish |
| kutubxona |
| kutubxona_fondi |
| xodimlar |
+---------------------+
5 rows in set (0.03 sec)

mysql> select *from adabiyot_turi;

Empty set (0.00 sec)

mysql> select *from fondni_toldirish;

Empty set (0.00 sec)

mysql> select *from kutubxona;

+---------------------+-------------+------------+
| Nomi | Manzili | Tel_raqami |
+---------------------+-------------+------------+
| Alisher_Navoiy | Toshkent_sh | 901578585 |
| Behbudiy | Andijon_sh | 917565656 |
| Yoshlar_kutubxonasi | Qoqon_sh | 933554949 |
| Elektron_k | Fargona_sh | 995842624 |
+---------------------+-------------+------------+
4 rows in set (0.00 sec)

mysql> select *from kutubxona_fondi;

Empty set (0.00 sec)

mysql> select *from xodimlar;

+------------+--------------+---------------+----------+---------+--------------+
| ismi | Familiyasi | Tugilgan_yili | Malumoti | Maoshi | Lavozimi |
+------------+--------------+---------------+----------+---------+--------------+
| Dilshodbek | Abdurazzaqov | 20.07.1980 | oliy | 2000000 | Sotuvchi |
| Alisher | Kadirov | 09.12.1980 | oliy | 2100000 | Sotuvchi |
| Oybek | Ergashev | 15.02.1990 | orta | 1500000 | kuryer |
| Botir | Shuhratov | 12.07.1987 | orta | 1300000 | Kutubxonachi |
| Shavkatjon | Tojiboyev | 2.05.1992 | oliy | 2800000 | Menejer |
+------------+--------------+---------------+----------+---------+--------------+
5 rows in set (0.00 sec)

mysql> select group_concat(Familiyasi) from xodimlar;

+---------------------------------------------------+
| group_concat(Familiyasi) |
+---------------------------------------------------+
| Abdurazzaqov,Kadirov,Ergashev,Shuhratov,Tojiboyev |
+---------------------------------------------------+
1 row in set (0.00 sec)

mysql> select group_concat(Familiyasi,'',ismi) from talabalar;

ERROR 1146 (42S02): Table 'kutubxona.talabalar' doesn't exist
mysql> select group_concat(Familiyasi,'',ismi) from xodimlar;
+----------------------------------------------------------------------------------------+
| group_concat(Familiyasi,'',ismi) |
+----------------------------------------------------------------------------------------+
| AbdurazzaqovDilshodbek,KadirovAlisher,ErgashevOybek,ShuhratovBotir,TojiboyevShavkatjon |
+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select bit_length(Familiyasi) from xodimlar;

+------------------------+
| bit_length(Familiyasi) |
+------------------------+
| 96 |
| 56 |
| 64 |
| 72 |
| 72 |
+------------------------+
5 rows in set (0.00 sec)

mysql> select bin(Familiyasi) from xodimlar;

+-----------------+
| bin(Familiyasi) |
+-----------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+-----------------+
5 rows in set (0.00 sec)

mysql> > select char(Familiyasi) from xodimlar;

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 '> select char(Familiyasi) from xodimlar' at line 1
mysql> > select char(Familiyasi) from xodimlar;
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 '> select char(Familiyasi) from xodimlar' at line 1
mysql> select elt(Familiyasi) from xodimlar;
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'elt'
mysql> select find_in_set(Familiyasi) from xodimlar;
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'find_in_set'
mysql> select find_in_set(Familiyasi,ismi) from xodimlar;
+------------------------------+
| find_in_set(Familiyasi,ismi) |
+------------------------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+------------------------------+
5 rows in set (0.00 sec)

mysql> select elt(Familiyasi,ismi) from xodimlar;

+----------------------+
| elt(Familiyasi,ismi) |
+----------------------+
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
+----------------------+
5 rows in set (0.00 sec)

mysql> > select char(Familiyasi,ismi) from xodimlar;

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 '> select char(Familiyasi,ismi) from xodimlar' at line 1
mysql> select hex(Familiyasi) from xodimlar;
+--------------------------+
| hex(Familiyasi) |
+--------------------------+
| 4162647572617A7A61716F76 |
| 4B616469726F76 |
| 4572676173686576 |
| 536875687261746F76 |
| 546F6A69626F796576 |
+--------------------------+
5 rows in set (0.00 sec)

mysql> select oct(Familiyasi) from xodimlar;

+-----------------+
| oct(Familiyasi) |
+-----------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+-----------------+
5 rows in set (0.00 sec)

mysql> select instr(Familiyasi) from xodimlar;

ERROR 1582 (42000): Incorrect parameter count in the call to native function 'instr'
mysql> select instr(Familiyasi,ismi) from xodimlar;
+------------------------+
| instr(Familiyasi,ismi) |
+------------------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+------------------------+
5 rows in set (0.00 sec)

mysql> select left(Familiyasi,7) from xodimlar;

+--------------------+
| left(Familiyasi,7) |
+--------------------+
| Abduraz |
| Kadirov |
| Ergashe |
| Shuhrat |
| Tojiboy |
+--------------------+
5 rows in set (0.00 sec)

mysql> select left(Familiyasi,5) from xodimlar;

+--------------------+
| left(Familiyasi,5) |
+--------------------+
| Abdur |
| Kadir |
| Ergas |
| Shuhr |
| Tojib |
+--------------------+
5 rows in set (0.00 sec)

mysql> select locate(Familiyasi,5) from xodimlar;

+----------------------+
| locate(Familiyasi,5) |
+----------------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+----------------------+
5 rows in set (0.00 sec)

mysql> select lower(Familiyasi) from xodimlar;

+-------------------+
| lower(Familiyasi) |
+-------------------+
| abdurazzaqov |
| kadirov |
| ergashev |
| shuhratov |
| tojiboyev |
+-------------------+
5 rows in set (0.00 sec)

mysql> select ltrim(Familiyasi) from xodimlar;

+-------------------+
| ltrim(Familiyasi) |
+-------------------+
| Abdurazzaqov |
| Kadirov |
| Ergashev |
| Shuhratov |
| Tojiboyev |
+-------------------+
5 rows in set (0.00 sec)

mysql> select avg(familiya) from xodimlar where malumoti='oliy';

ERROR 1054 (42S22): Unknown column 'familiya' in 'field list'
mysql> select avg(familiyasi) from xodimlar where malumoti='oliy';
+-----------------+
| avg(familiyasi) |
+-----------------+
| 0 |
+-----------------+
1 row in set (0.00 sec)

mysql> select avg(familiyasi * ismi) from xodimlar;

+------------------------+
| avg(familiyasi * ismi) |
+------------------------+
| 0 |
+------------------------+
1 row in set (0.00 sec)

mysql> select count(familiyasi) from xodimlar;

+-------------------+
| count(familiyasi) |
+-------------------+
| 5 |
+-------------------+
1 row in set (0.00 sec)

mysql> > select count(distinct familiyasi) from xodimlar;

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 '> select count(distinct familiyasi) from xodimlar' at line 1
mysql> select count(all familiyasi) from xodimlar;
+-----------------------+
| count(all familiyasi) |
+-----------------------+
| 5 |
+-----------------------+
1 row in set (0.00 sec)

mysql> select group_concat(

-> -> Ismi) from talabalar;
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 talabalar' at line 2
mysql> select group_concat(
-> -> Ismi) from talabalar;
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 talabalar' at line 2
mysql> select group_concat(
-> -> Ismi) from talabalar;
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 talabalar' at line 2
mysql> select group_concat(ismi) from xodimlar;
+-------------------------------------------+
| group_concat(ismi) |
+-------------------------------------------+
| Dilshodbek,Alisher,Oybek,Botir,Shavkatjon |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql> select sum(ismi) from xodimlar;

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

mysql>