- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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?
- What kind of output is returned by MySQL scalar subquery? What are the restrictions on using it with MySQL query?
- How to get number of rows in a table without using count(*) MySQL query?
- Get the number of columns in a MySQL table?
- Count rows having three or more rows with a certain value in a MySQL table
- MySQL query to find the number of rows in the last query
- What are the advantages, disadvantages and restrictions of using MySQL triggers?
- What is the query to check Character set of the columns of MySQL table?
- How can we list all the columns of a MySQL view as we can list the columns of a MySQL table?
- MySQL query to count the number of 0s and 1s from a table column and display them in two columns?
- Set all the columns of a MySQL table to a particular value with a single query
- How to select the table with the greatest number of columns in MySQL?
- How to find the number of columns in a MySQL table?

Advertisements