Understanding the limitations of MySQL database on the server light mark

Guidance:Starting from MySQL 5.0.2MysqlThe _ stmt_attr_set () c api function implements the server-side cursor.Server cursorAllows the server to generate a result set, but does not transmit it to the client unless the client requests these rows. For example, if the client executes a query but is only interested in 1st rows, the remaining rows will not be transmitted.

The cursor is read-only and cannot be used to update rows.

Update where current of and delete where current of are not implemented because the updatable cursor is not supported.

The cursor cannot be kept (open again after submission ).

The cursor is insensitive.

The cursor cannot be rolled.

The cursor is not named. The statement handler acts as the cursor ID.

Only one cursor can be opened for each pre-processing statement. If you need multiple cursors, you must process multiple statements.

If the statement is not supported in Preprocessing mode, you cannot use the cursor on the statement that generates the result set. Including check tables, handler read, and show binlog events statements.

The limitations of MySQL databases on the backend are described above. Therefore, it can be concluded that database management is not so easy. Database Management is subject to many constraints, I hope the content mentioned above will be helpful to you.