mysql_kill() - mysql/mysql.h

 Note


          As of MySQL 5.7.11, mysql_kill() is
          deprecated and will be removed in a future version of MySQL.
          Instead, use mysql_query() to
          execute a KILL statement.NoteAs of MySQL 5.7.11, mysql_kill() is
          deprecated and will be removed in a future version of MySQL.
          Instead, use mysql_query() to
          execute a KILL statement.mysql_kill()mysql_query()mysql_query()KILLKILLAsks the server to kill the thread specified by
        pid.pidThis function is deprecated. It is preferable to use
        mysql_query() to issue an SQL
        KILL statement instead.mysql_query()mysql_query()KILLKILLmysql_kill() cannot handle
        values larger than 32 bits, but to guard against killing the
        wrong thread returns an error in these cases:mysql_kill()mysql_kill()If given an ID larger than 32 bits,
            mysql_kill() returns a
            CR_INVALID_CONN_HANDLE
            error.
          
            After the server's internal thread ID counter reaches a
            value larger than 32 bits, it returns an
            ER_DATA_OUT_OF_RANGE error
            for any mysql_kill()
            invocation and mysql_kill()
            fails.If given an ID larger than 32 bits,
            mysql_kill() returns a
            CR_INVALID_CONN_HANDLE
            error.
          
            After the server's internal thread ID counter reaches a
            value larger than 32 bits, it returns an
            ER_DATA_OUT_OF_RANGE error
            for any mysql_kill()
            invocation and mysql_kill()
            fails.If given an ID larger than 32 bits,
            mysql_kill() returns a
            CR_INVALID_CONN_HANDLE
            error.If given an ID larger than 32 bits,
            mysql_kill() returns a
            CR_INVALID_CONN_HANDLE
            error.mysql_kill()mysql_kill()CR_INVALID_CONN_HANDLECR_INVALID_CONN_HANDLEAfter the server's internal thread ID counter reaches a
            value larger than 32 bits, it returns an
            ER_DATA_OUT_OF_RANGE error
            for any mysql_kill()
            invocation and mysql_kill()
            fails.After the server's internal thread ID counter reaches a
            value larger than 32 bits, it returns an
            ER_DATA_OUT_OF_RANGE error
            for any mysql_kill()
            invocation and mysql_kill()
            fails.ER_DATA_OUT_OF_RANGEER_DATA_OUT_OF_RANGEmysql_kill()mysql_kill()mysql_kill()mysql_kill()

Syntax

int mysql_kill(MYSQL *mysql, unsigned long
        pid)

Example

Output / Return Value

 Zero for success. Nonzero if an error occurred.

Limitations

Alternatives / See Also

Reference