2-Laboratoriya ishi Mavzu: sql da standart funktsiyalar bilan ishlash Ishdan maqsad

BIN(N)

SQL> SELECT BIN(12);

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

| BIN(12) |

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

| 1100 |

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

1 row in set (0.00 sec)

1 row in set (0.00 sec)

CHARACTER_LENGTH(str)

CONCAT (str1, str2, …)

SQL> SELECT CONCAT('My', 'S', 'QL');

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

| CONCAT('My', 'S', 'QL') |

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

| MySQL |

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

1 row in set (0.00 sec)

CONCAT_WS(separator,str1,str2,…)

SQL> SELECT CONCAT_WS(',','First name','Last Name' );

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

| CONCAT_WS(',','First name','Last Name' ) |

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

| First name,Last Name |

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

1 row in set (0.00 sec)


Topshiriq: Har bir talaba o’ziga berilgan predmet soha mavzusi bo’yicha standart

funksiyalardan foydalanib so’rovlar yaratishi va natijasi bilan ko’rsatib o’tishi kerak.