PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
mysql> SET block_encryption_mode = 'aes-256-cbc'; mysql> SET @key_str = SHA2('My secret passphrase',512); mysql> SET @init_vector = RANDOM_BYTES(16); mysql> SET @crypt_str = AES_ENCRYPT('text',@key_str,@init_vector); mysql> SELECT ...If you want to ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
Doing so does not in itself select any database to work with, but that is okay. The following queries are equivalent: mysql> SELECT VERSION(), CURRENT_DATE; mysql> select version(), current_date; mysql> SeLeCt vErSiOn(), current_DATE; Here is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
SELECT statements, these rules apply regarding acceptable forms of SELECT query expressions that you can refer to in an ON DUPLICATE KEY UPDATE clause: References to columns from queries on a single table, which may be a derived table. References to ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. As mentioned previously, you can use a (field_name_or_user_var, ...) list of one or more XML fields (to select desired fields only) or user variables (to store the corresponding field values for later ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, replica_gtid_executed); This statement returns any GTIDs that are in source_gtid_executed but not in ... This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
Otherwise, the audit log selects no audit events from the session for processing. To assign a filter explicitly to a particular user account or accounts, define the filter, then assign it to the relevant accounts: SELECT ... Note As of MySQL 5.7.13, ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
(For the general syntax for specifying tables in a SELECT statement, see Section 13.2.9.2, “JOIN Clause”.) The syntax for referring to an individual table, including index hints, looks like this: tbl_name [[AS] alias] [index_hint_list] ... Index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
performs the SELECT with shared next-key locks or as a consistent read, as for INSERT ... When a SELECT is used in the constructs REPLACE INTO t SELECT ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that ...