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.
Dostları ilə paylaş: |