Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-query.html
int mysql_query(MYSQL *mysql, const char *stmt_str) Description Executes the SQL statement pointed to by the null-terminated string stmt_str. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or \g. If ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect-dns-srv.html
MYSQL * mysql_real_connect_dns_srv(MYSQL *mysql, const char *dns_srv_name, const char *user, const char *passwd, const char *db, unsigned long client_flag) Description Note mysql_real_connect_dns_srv() is a synchronous function.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-prepare.html
int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long length) Description Given the statement handler returned by mysql_stmt_init(), prepares the SQL statement pointed to by the string stmt_str and returns a status value. You ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-store-result.html
int mysql_stmt_store_result(MYSQL_STMT *stmt) Description Result sets are produced by calling mysql_stmt_execute() to executed prepared statements for SQL statements such as SELECT, SHOW, DESCRIBE, and EXPLAIN. By default, result sets for ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first condition is removed, leaving WHERE column1='y' See: /sql/sql_select.cc, remove_eq_conds(). A transformation also takes ...
https://dev.mysql.com/doc/workbench/en/wb-basic-foreign-key.html
Select the table tool again and place another table on the canvas. First, click the invoice_item table; notice that a red border indicates that this table is selected. This creates a foreign key in the invoice_item table, the table on the ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
User-level locks are controlled with the SQL functions GET_LOCK(str,timeout) IS_FREE_LOCK(str) IS_USED_LOCK(str) RELEASE_LOCK(str) They can be used at places where SQL statements accept SQL functions. Depending on their appearance in the select ...
https://dev.mysql.com/doc/internals/en/external-lock.html
Synopsis virtual int external_lock ( thd, lock_type); THD * thd ; int lock_type ; Description This is the external_lock method. The locking methods for mysql section in lock.cc has additional comments on this topic that may be useful to read. If you ...
https://dev.mysql.com/doc/internals/en/class-procedure-constructor.html
Prototype: n/a The class constructors prototype signature is completely up to you. The only place where objects are instantiated is your own init callback. To initialize your derived procedure object you have to pass on the select_result pointer ...
https://dev.mysql.com/doc/workbench/en/wb-develop-object-management-inspector.html
The Schema Inspector and Table Inspector each include the ability to analyze and repair tables, and also view table metrics. Schema Inspector Use the Schema Inspector to browse general information from schema objects (shown in the figure that ...