Select*fromStudent_infoWHEREName='ABCD';Emptyset(0.00sec) We can see that the output is the empty set and the execution time. This means the query is correct, but the MySQL table does not have the name "ABCD"."/> Select*fromStudent_infoWHEREName='ABCD';Emptyset(0.00sec) We can see that the output is the empty set and the execution time. This means the query is correct, but the MySQL table does not have the name "ABCD".">
search

Home  >  Article  >  Database  >  What does "empty set" in MySQL result set mean?

What does "empty set" in MySQL result set mean?

PHPz
PHPzforward
2023-09-09 12:13:09971browse

What does empty set in MySQL result set mean?

If there is an "empty set" in the result set of a MySQL query, it means that MySQL did not return any rows and there were no errors 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 output is empty set and the execution time. This means the query is correct, but the MySQL table does not have the name "ABCD".

The above is the detailed content of What does "empty set" in MySQL result set mean?. For more information, please follow other related articles on the PHP Chinese website!

mysql
Statement：
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete
Previous article：Master-slave replication and high availability architecture in MySQLNext article：Master-slave replication and high availability architecture in MySQL

Related articles

See more