Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote character. mysql> SET sql_mode = ''; mysql> SELECT NOT 1 BETWEEN -5 AND 5; -> 0 mysql> SET sql_mode = 'HIGH_NOT_PRECEDENCE'; mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
String Type Storage Requirements In the following table, M represents the declared column length in characters for nonbinary string types and bytes for binary string types. Data Type Storage Required CHAR(M) The compact family of InnoDB row formats ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
The path column is widened to CHAR(200) to ensure that there is room for the longer path values produced by the recursive SELECT. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db) Description Changes the user and causes the database specified by db to become the default (current) database on the connection specified by mysql. In ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-connect.html
MYSQL * mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd) Description This function is deprecated.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. The string in the from argument is encoded in hexadecimal format, with each character ...The result is placed in the to argument, followed by a terminating null ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
MYSQL_OPT_CONNECT_ATTR_ADD (argument types: char *, char *) This option adds an attribute key-value pair to the current set of connection attributes to pass to the server at connect time. MYSQL_OPT_USER_PASSWORD (argument types: unsigned int *, char ... int mysql_options4(MYSQL *mysql, enum mysql_option option, const void *arg1, const void *arg2) Description mysql_options4() is similar to mysql_options() but has an extra fourth argument so that two values can be passed for the option specified in the second ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. In this case, the function cannot escape quote characters ...