<div>
Need to put it in a query from a database, not as a pivot table
</div>


Need to put it in a query from a database, not as a pivot table

<div>
Hi!<br />
<br />
If you look at the examples then you will see how this pivot query (executed inside the database) <br />
transforms your data in pivot like manner into the format you are asking for. <br />
<br />
Regards,<br />
&nbsp; &nbsp;Tomas Helgi
</div>


Hi!

If you look at the examples then you will see how this pivot query (executed inside the database)
transforms your data in pivot like manner into the format you are asking for.

Regards,
   Tomas Helgi

<div>
<div class="content wysiwyg-content">
Is it possible to get a list of columns from a query?<br />
<br />
I have a table:-<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/03_w10/901392/1.png" target="_blank" title="SQL Table (3 KB)"><img alt="SQL Table" class="file-block lazyload" style="max-width: 382px;" data-src="https://filedb.experts-exchange.com/incoming/2015/03_w10/901392/1.png" /></a><br />
But I want it to display the contents as:-<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/03_w10/901393/2.png" target="_blank" title="2 (2 KB)"><img alt="2" class="file-block lazyload" style="max-width: 479px;" data-src="https://filedb.experts-exchange.com/incoming/2015/03_w10/901393/2.png" /></a><br />
I know I could use a query such as:-<br />

<pre><code id="code-10-28629062-1">Select DISTINCT `question` FROM `myTable` WHERE `surveyID` = 1; </code></pre>
<br />
Then build up the SQL statement to display my table.<br />
<br />
I was going to use SQLite but think its not powerful enough to do this, so was thinking of using MySQL.<br />
<br />
Any ideas if this is even possible, and if possible how can I do it?<br />
<br />
Thank you
</div>
</div>


1.png

2.png

Is it possible to get a list of columns from a query?

I have a table:-


But I want it to display the contents as:-


I know I could use a query such as:-
(CODE)

Then build up the SQL statement to display my table.

I was going to use SQLite but think its not powerful enough to do this, so was thinking of using MySQL.

Any ideas if this is even possible, and if possible how can I do it?

Thank you

Get columns from query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.