What is the meaning of ‘empty set’ in MySQL result set?

If there is ‘empty set’ in the result set of MySQL query then it means that MySQL is returning no rows and no error also in the query. It can be understood with the help of the following example −

mysql> Select * from Student_info WHERE Name = 'ABCD';
Empty set (0.00 sec)

We can see the empty set and execution time as output. It means that the query is correct but the MySQL table is not having the name ‘ABCD’.

Nitya Raut

Updated on 22-Jun-2020 11:53:16

• Related Questions & Answers
• How to select an empty result set in MySQL?
• In MySQL, how can we randomize set of rows or values in the result set?
• Set user variable from result of query in MySQL?
• Set the result of a query to a variable in MySQL?
• What is the meaning of <> in MySQL query?
• What is the importance of the order of Columns in the SET clause of UPDATE statement? Will it make big difference in result set returned by MySQL?
• How Can MySQL operator precedence affect result set?
• How to make MySQL result set the same as specified?
• What is the meaning of supernatural power?
• What is the meaning of medical examination?
• What is the meaning of eCommerce store?
• How to sort MySQL output on the basis of the column which is not in the result set?
• How instruction set architectures check the result of operations?
• How is it possible to filter out the duplications in the rows of result set return by MySQL?
• Set the default character set in MySQL