Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

group_concat mysql

 //returns the concatenated string from multiple rows into a single string
 SELECT emp_id, emp_fname, emp_lname, dept_id,     
GROUP_CONCAT(designation) as "designation" FROM employee group by emp_id;  
Source by database.guide #
 
PREVIOUS NEXT
Tagged: #mysql
ADD COMMENT
Topic
Name
3+5 =