MySQL : Multiple row as comma separated single row

by

Use GROUP_CONCAT FUNCTION

http://dev.mysql.com/tech-resources/articles/4.1/grab-bag.html

 SELEct m.meal_Id, 
        GROUP_CONCAT(dish_id) dish_ids, 
        GROUP_CONCAT(dish_name) dish_names
 FROM DISH_HAS_DISHES m JOIN DISH d ON (m.dish_id = d.dish_id)
 GROUP BY meal_Id

More Related Contents:

  1. How do I store large no.of small entries in Mysql?
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. Location of my.cnf file on macOS
  8. How to do Inheritance Modeling in Relational Databases?
  9. Maximum number of records in a MySQL database table
  10. Swapping column values in MySQL
  11. JOIN queries vs multiple queries
  12. Is the primary key automatically indexed in MySQL?
  13. Storing Data in MySQL as JSON
  14. MySql: MyISAM vs. Inno DB! [closed]
  15. Import SQL file into mysql
  16. How to skip certain database tables with mysqldump?
  17. “where 1=1” statement [duplicate]
  18. How do you debug MySQL stored procedures?
  19. Meaning of “n:m” and “1:n” in database design
  20. How to set a MySQL row to READ-ONLY?
  21. MySQL: LAST_INSERT_ID() returns 0
  22. mySQL – Create a New Table Using Data and Columns from Three Tables
  23. Calculating a Moving Average MySQL?
  24. Case Sensitive collation in MySQL
  25. Can I launch a trigger on select statement in mysql?
  26. Can’t import database through phpmyadmin file size too large
  27. How do you write a case insensitive query for both MySQL and Postgres?
  28. What is the best way to do incremental backups in MySQL?
  29. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  30. How to store data with dynamic number of attributes in a database

Leave a Comment