Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
A UNIQUE index may display as MUL if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM ...
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
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
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
As a development technique to guard against a runaway recursive CTE, you can force termination by placing a limit on execution time: The cte_max_recursion_depth system variable enforces a limit on the number of recursion levels for CTEs. The path ...
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 ...