Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

mysql equi of wm_concat

Tags:

mysql

What is the mysql equi of wm_concat?

like image 861
Pinaz Avatar asked Feb 28 '23 00:02

Pinaz

2 Answers

GROUP_CONCAT() is the MySQL equivalent of WM_CONCAT() in Oracle.

like image 89
LAZ Avatar answered Mar 06 '23 22:03

LAZ

 
concat_ws

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws

like image 23
Sarfraz Avatar answered Mar 06 '23 21:03

Sarfraz
Sign in to Comment

Related questions

MySQL Views: Referencing one calculated field (by name) in another calculated field
Convert a stored md5 string to a decimal value in MySQL
MySQL limit results per category
How to export data from the database into .csv format programmatically?
Prepared statement with PHP and MySQL without using mysqli
MySQL find nearest matching row
what is wrong with this sql query?
Optimize SQL query
safest place to store php values for msql_connect?
How to count all NULL values in a table?
Why is it still possible to insert a foreign key that doesn't exist?
How to check with python if a table is empty?
MySQL and Matlab
What are the weaknesses of this user authentication method?
Can MySQL Nested Select return list of results
In Django, I want to insert a database record by sending myself an email?
I need unusual ordering mysql results
Why does this properly escaped SQL query fail?
MySQL 5.1.41 leading zero is deleted
Cannot insert non latin symbols in MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!