PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... Replacing a User Filter In some cases, the filter definition can be changed dynamically. A new filter can be replaced with the original one by using a ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. Data masking ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system database, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the SUPER privilege. Normally, a ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. By default, the server interprets ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. If the OR REPLACE clause is present, you must also have the DROP privilege for the view. By default, a new ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. dictionary_name: A string that names the dictionary containing the term ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a database. These ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--ignore, -i Command-Line Format --ignore See the description for the --replace option. --replace, -r Command-Line Format --replace The --replace and --ignore options control handling of input rows that duplicate existing rows on unique key values.
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name } CREATE DATABASE creates a database with the given name. To use this statement, you need ...For information about character set and collation names, see Chapter 10, Character Sets, Collations, ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. Important When a database ...TEMPORARY tables are automatically removed when the session that created them ...