How to fix CR_COMMANDS_OUT_OF_SYNC (2014): Commands out of sync; you can't run this command now in MySQL

// PHP mysqli example
$mysqli->multi_query("CALL my_procedure()");

// Process all result sets
do {
    if ($result = $mysqli->store_result()) {
        while ($row = $result->fetch_assoc()) {
            // Process your rows
        }
        $result->free();
    }
} while ($mysqli->more_results() && $mysqli->next_result());

// Now you can safely execute another query

# Python MySQLdb example
cursor.callproc('my_procedure')

# Consume all result sets
for result in cursor.stored_results():
    rows = result.fetchall()
    # Process rows

# Now safe to execute another query

// C API example
MYSQL_RES *result = mysql_store_result(conn);
if (result) {
    // Process result
    while ((row = mysql_fetch_row(result))) {
        // Handle row
    }
    mysql_free_result(result);  // Critical: free before next query
}

// Now safe to execute another query
mysql_query(conn, "SELECT * FROM users");

// Node.js mysql2 example
connection.query('SELECT * FROM table1', (err, results) => {
    // Process results
    // Results are automatically consumed here

    // Now safe to execute another query
    connection.query('SELECT * FROM table2', (err, results) => {
        // Process second query
    });
});

// Buffered query - entire result retrieved at once
MYSQL_RES *result = mysql_store_result(conn);
if (result) {
    // All rows are now in memory
    // Safe to execute other queries even before processing all rows
    mysql_free_result(result);
}

// PHP - enable CLIENT_MULTI_RESULTS
$mysqli = new mysqli($host, $user, $pass, $db);
$mysqli->options(MYSQLI_OPT_CONNECT_FLAGS, MYSQLI_CLIENT_MULTI_RESULTS);

# Python - enable multiStatements in connection string
connection = mysql.connector.connect(
    host='localhost',
    user='user',
    password='password',
    database='mydb',
    allow_multi_results=True
)

// Node.js mysql2 - enable multipleStatements
const connection = mysql.createConnection({
    host: 'localhost',
    user: 'user',
    password: 'password',
    database: 'mydb',
    multipleStatements: true
});

// Node.js with connection pool
pool.getConnection((err, connection) => {
    connection.query('CALL my_proc()', (err, results) => {
        // Process ALL result sets
        if (Array.isArray(results)) {
            results.forEach(resultSet => {
                // Process each result set
            });
        }

        // Release connection only after ALL results consumed
        connection.release();
    });
});