What are the restrictions, in terms of a number of rows and columns, with MySQL query having no table list?

The restriction on MySQL query having a notable list is that it can return, as a result, exactly one row but that result can contain multiple columns.

Example

mysql> Select 65/NULL,65+NULL,65*NULL,65-NULL,65%NULL;
+------------+--------------+-------------+-------------+---------+
| 65/NULL    | 65+NULL      | 65*NULL     | 65-NULL     | 65%NULL |
+------------+--------------+-------------+-------------+---------+
|       NULL |         NULL |        NULL |        NULL |    NULL |
+------------+--------------+-------------+-------------+---------+
1 row in set (0.00 sec)

In the above example, we can see that MySQL returns only one row with five columns, having the result of five expressions, as a result when we do not have any table list in the statement.

vanithasree

Updated on 22-Jun-2020 10:51:26

• Related Questions & Answers
• Get the number of rows in a particular table with MySQL
• Count the number of columns in a MySQL table with Java
• What happens if MySQL query returns no rows?
• Get the number of columns in a MySQL table?
• What are the advantages, disadvantages and restrictions of using MySQL triggers?
• What kind of output is returned by MySQL scalar subquery? What are the restrictions on using it with MySQL query?
• What is the query to check Character set of the columns of MySQL table?
• What are the restrictions of regular grammar?
• MySQL query to find the number of rows in the last query
• How to get number of rows in a table without using count(*) MySQL query?
• How can we list all the columns of a MySQL view as we can list the columns of a MySQL table?
• Count rows having three or more rows with a certain value in a MySQL table
• How to find the number of columns in a MySQL table?
• How to select the table with the greatest number of columns in MySQL?
• MySQL query to count the number of 0s and 1s from a table column and display them in two columns?