MySQL-এ CONCAT() ফাংশনের বিকল্প CONCAT_WS()

হ্যাঁ, একটি বিকল্প হলো CONCAT_WS()।

টেবিল তৈরি করা

mysql> create table DemoTable 
( 
  StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, 
  StudentName varchar(100) 
); 
Query OK, 0 rows affected (0.74 sec)

রেকর্ড ইনসার্ট করা

mysql> insert into DemoTable(StudentName) values('Chris'); 
Query OK, 1 row affected (0.13 sec) 
mysql> insert into DemoTable(StudentName) values('Robert'); 
Query OK, 1 row affected (0.14 sec) 
mysql> insert into DemoTable(StudentName) values('Bob'); 
Query OK, 1 row affected (0.12 sec)

সকল রেকর্ড প্রদর্শন

mysql> select *from DemoTable;

আউটপুট

+-----------+-------------+ 
| StudentId | StudentName | 
+-----------+-------------+ 
| 1         | Chris       | 
| 2         | Robert      | 
| 3         | Bob         | 
+-----------+-------------+ 
3 rows in set (0.00 sec)

CONCAT_WS() ব্যবহার উদাহরণ

mysql> select concat_ws(SPACE(2), 'Student Name is:',StudentName) from DemoTable;

আউটপুট

+-----------------------------------------------------+ 
| concat_ws(SPACE(2), 'Student Name is:',StudentName) | 
+-----------------------------------------------------+ 
| Student Name is:  Chris                             | 
| Student Name is:  Robert                            | 
| Student Name is:  Bob                               | 
+-----------------------------------------------------+ 
3 rows in set (0.04 sec)