What are the limitations on the number of rows and columns when querying MySQL without a list of tables?

The limitation on MySQL queries with significant lists is that it can only return one row as a result, but the 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 only returns one row and five columns, with the results of five expressions. This is when we The result when there is no table list in the statement.

The above is the detailed content of What are the limitations on the number of rows and columns when querying MySQL without a list of tables?. For more information, please follow other related articles on the PHP Chinese website!