Transformation of records 1 column 3 row -> 1 row 3 column

Posted by Nehal Rupani on Stack Overflow See other posts from Stack Overflow or by Nehal Rupani
Published on 2010-06-03T15:17:10Z Indexed on 2010/06/03 15:24 UTC
Read the original article Hit count: 280

Filed under:

mysql

|

mysqli

First look at below query

SELECT count(id) as total_record, 
  id, modeller, MONTHNAME(completed_date) as current_month,
  Quarter(completed_date) as current_quarter, Difficulty, 
  YEAR(completed_date) as current_year 
FROM model 
WHERE modeller != '' 
  AND completed_date BETWEEN '2010-04-01' AND '2010-05-31' 
  AND Difficulty != '' 
Group by Difficulty, 
  Month(completed_date) 
Order by Month(completed_date) ASC

Results I am getting is

Modeller  Month Year  Difficulty
-------------------------------------
XYZ       Jan   2010   23
XYZ       Jan   2010   14
XYZ       Jan   2010   15
ABC       Feb   2010    5
ABC       Feb   2010   14
ABC       Feb   2010    6

I want result like

Modeller Month  Year   Difficulty
--------------------------------------
XYZ      Jan    2010   23, 14, 15
ABC      Feb    2010    5, 14, 6

My database is Mysql for application i am developing so any help would be greatly appericated.

© Stack Overflow or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about mysqli

MySQLi PHP: Check if SQL INSERT query was fully successful using MySQLi

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have this big function that gets a lot of different data and insert it into multiple tables.. Not all the data is always available so not all the SQL INSERT queries are successful. I need to check which SQL INSERT query was fully successful and which wasn't to the do something with this data… >>> More
How to completely disable Mysqli

as seen on Server Fault - Search for 'Server Fault'
It seems the new hacker tool refref has been launched, and apparently it abuses a bug in the mysqli extension. Now I do not use mysqli at all for my websites, so i thought the best way to fight off this refref tool was to completely disable mysqli. These are the settings i have set in my php.ini… >>> More
PHP MySQLi timeout not working

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys I have a weird problem with mysqli timeout options, here you go: I am using mysqli_init() and real_connect() in order to set MYSQLI_OPT_CONNECT_TIMEOUT $this->__mysqli = mysqli_init(); if(!$this->__mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT,1)) throw new Exception('Timeout… >>> More
Extending MySQLi

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I've run into problems extending the MySQLi class. It won't let me add any properties. class MySQLii extends MySQLi { public $database; public function MySQLii($host, $username, $password, $database){ // Initialize MySQLi parent::MySQLi($host, $username, $password, $database); … >>> More
Non-static method mysqli::init() cannot be called statically

as seen on Stack Overflow - Search for 'Stack Overflow'
http://php.net/manual/en/mysqli.init.php $ConnectionResource = mysqli::init(); The above code fails with: Fatal error: Non-static method mysqli::init() cannot be called statically How come? >>> More