Understanding Mysql prepare preprocessing statements, mysqlprepare
MySQL 5.1 supports premade statements on the server side. If you use a suitable client programming interface, this support can take advantage of the efficient client/server binary
MySQL 5.1 provides support for prefabricated statements on the server side. If you use the appropriate client-side programming interface, this support can play the advantage of an efficient client/server binary protocol implemented in MySQL 4.1. The
Mysql-prepare statementsFeature Description:MySQL Prepare statement usageIn order to prepare the statement using MySQL, you need to use the other three MySQL statements as follows:PREPARE -The statement that is ready to be executed.Execute -executes
MySQL prepare usage, mysqlprepare
MySQL officially referred to prepare, execute, and deallocate as prepare statement, which is often called a [pre-processing STATEMENT]. The following is a detailed introduction to this STATEMENT.
Sample Code
PREPARE
If you are evaluating the pressure of a MySQL database, you can use Sysbench to test
The concrete operation out, installs the Sysbench tool first, installs the operation as follows:
Installation Environment
CentOS Release 5.4 (Final)MySQL 5.1.40
PREPARE statement_name from sql_text/* definition */
EXECUTE statement_name [USING variable [, variable ...]/* Run pre-processing statement */
deallocate PREPARE statement_name/* Delete definition */
This is used in my project and used as a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.