Search Results
https://dev.mysql.com/doc/refman/8.4/en/roles.html
To restore modification privileges to the role, simply re-grant them: GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write'; Now rw_user1 again has modification privileges, as do any other accounts granted the app_write role. Like user accounts, ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
For a value containing more than one SET element, it does not matter what order the elements are listed in when you insert the value. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Two of those invocations insert a row, and MySQL logs a SELECT statement for each of them. The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. You should also not confuse it with the VALUES() function that refers to column values in INSERT ... In place ... VALUES is a DML statement which returns a set of one or more rows as a ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
If, after registering a FIDO/FIDO2 device on the client host, the device is reset or a different device is inserted, authentication fails. $> mysql --user=u2 --password1 --register-factor=2 Enter password: (enter factor 1 password) Please insert ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
It returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
When set to a value other than the default (PREFERRED), an ssl_mode entry is inserted under the [metadata_cache] section in the generated configuration file. mysqlrouter Option Summaries mysqlrouter Option Descriptions MySQL Router accepts command ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. This topic describes how to prepare the data to use for a classification machine learning model. The classification ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE DATABASE recommendation_data; mysql> USE recommendation_data; Create the table to insert the sample data into. mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...