Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. When validate_password.check_user_name is enabled, it has these effects: Checking occurs in all contexts for which ... This ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. MySQL is available for Microsoft Windows 64-bit operating systems only. There are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To backup a replica database, add the --replica-info option to your backup command. To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. MySQL Enterprise Backup does not include ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-user-password.html
Execute the following statement, where newuser is the new user name, and newpass is the new password: SET PASSWORD FOR 'newuser'@'127.0.0.1' = PASSWORD('newpass'); Use mcmd for the user name if you have not changed it—that is, if mcmd-user has ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
To set an attribute on the process level, use a set statement that contains an attribute assignment having the form attribute_name:process_name=value. The set statement does not contain any additional parameters that only affect a ndb_mgmd or mysqld ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
Attributes defined with mysql_bind_param() apply to nonprepared statements executed in blocking fashion with mysql_real_query() or mysql_query(), or in nonblocking fashion with mysql_real_query_nonblocking(). For a description of the members of the ... bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), available as of MySQL 8.0.23, enables defining attributes that apply to the next query sent to the ...
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. If you must change the character set of the connection, use the ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-param.html
bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_prepare(). The client library expects the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-num-rows.html
The use of mysql_stmt_num_rows() depends on whether you used mysql_stmt_store_result() to buffer the entire result set in the statement handler. mysql_stmt_num_rows() is intended for use with statements that return a result set, such as SELECT. For ... uint64_t mysql_stmt_num_rows(MYSQL_STMT *stmt) Description Returns the number of rows in the result ...