Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Putting database-intensive operations into stored procedures lets you define an API for your database application. You can reuse this API across multiple applications and multiple programming languages. This technique avoids duplicating database ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-authentication.html
#define MYSQL_DRIVER_CONNECT_ATTR_BASE 0x00004000 // Custom constants used for callback #define CB_FIDO_GLOBAL MYSQL_DRIVER_CONNECT_ATTR_BASE + 0x00001000 #define CB_FIDO_CONNECTION MYSQL_DRIVER_CONNECT_ATTR_BASE + 0x00001001 // Usage example // ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-datatypes.html
The following table illustrates how Connector/ODBC maps the server data types to default SQL and C data types.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-callproc.html
Syntax: result_args = cursor.callproc(proc_name, args=()) This method calls the stored procedure named by the proc_name argument. The args sequence of parameters must contain one entry for each argument that the procedure expects. Result sets ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
00 2b 79 44 26 2f 5a 5a 33 30 35 5a 47 00 6d 79 .+yD&/ZZ305ZG.my 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 sql_native_passw 6f 72 64 00 ord Note The auth-plugin-data is the concatenation of strings auth-plugin-data-part-1 and ...
https://dev.mysql.com/doc/internals/en/dbug-sleep.html
open_tables(...) DBUG_EXECUTE_IF("sleep_open_and_lock_after_open", { const char *old_proc_info= thd->proc_info; thd->proc_info= "DBUG sleep"; my_sleep(6000000); thd->proc_info= old_proc_info;}); lock_tables(...) In this case, if the 'debug' keyword ... In cases where the normal server code does not have a block point at the critical place, one can insert an artificial synchronization ...
https://dev.mysql.com/doc/internals/en/error-messages-storage-engine.html
To add error messages for table handlers, the following example may be helpful. Purpose: Implement the handler::get_error_message function as ha_federated::get_error_message to return the handler-specific error message. When you have returned the ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The compromise taken here is to accept that the resulting string may exceed the destination field length by five characters in the worst case. The bugfix for http://bugs.mysql.com/4937 (INSERT + SELECT + UNION ALL + DATE to VARCHAR(8) conversion ...
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
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 ...