mysql计算列数,当返回的列数是动态的时，如何计算MySQL查询的列数？

Is it possible to retrieve the count of the number of columns a query returns? This can be easily done with a bound scripting language such as php, but I'm looking for db only solution.

Example:

CountCols(SELECT 'a','b','c')

=> 3

CountCols(SELECT * FROM information_schema.session_variables)

=> 2

解决方案

Would this work for you?

select

count(*)

from

`information_schema`.`columns`

where

`table_schema` = 'my_table_schema' and `table_name` = 'my_table_name';

You only need to use table_schema if the table name exists in more than one database.

Based on your response comment, you are looking to count a dynamic number of columns. You may be able to do this with a temporary table, but you cannot access the data of a temporary table without possibly installing a patch.

Of note, there is a similar outstanding SO question asking how to select columns from a temporary table.