MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

MySQL table to matrix array
Posted by: Øyvind Norli
Date: April 25, 2016 05:56AM

Hi, I have a mysql table "movie" with the following columns:

"title", "year", "director".

Example:
Spartacus 1960 Stanley Kubrick
Yojimbo 1961 Akira Kurosawa

Can I create a matrix view with a SELECT statement like this?

1960 1961
Stanley Kubrick Spartacus
Akira Kurosawa Yojimbo

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL table to matrix array
Øyvind Norli
April 25, 2016 05:56AM
Re: MySQL table to matrix array
Peter Brawley
April 25, 2016 08:14AM
Re: MySQL table to matrix array
Øyvind Norli
April 27, 2016 04:55AM
Re: MySQL table to matrix array
Peter Brawley
April 27, 2016 08:11AM
Re: MySQL table to matrix array
Rick James
May 01, 2016 10:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.