MySQL 2014 error (2014) commands out of sync; you can't run this command now command solve the problem of non-synchronization errors

Today, I am suffering from a MySQL 2014 error for a long time.

There is no solution to this problem. After my problem is solved, I found that this is caused by function usage and is not a MySQL bug.

Find an articleArticle, Very helpful

Command not synchronized

If the "command is not synchronized" error occursCodeYou are calling client functions in the wrong order.

For example, if you are using mysql_use_result () and want to execute a new query before calling mysql_free_result (), this problem occurs.

This problem also occurs if you try to execute two queries but do not call mysql_use_result () or mysql_store_result () between the two queries.

Summarize my questions,

In a SELECT statement, such as "select * from ...... "," Select func_xxx () "requires mysql_store_result () or mysql_use_result