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!