Search Results
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... Replacement of Event Field Values Audit filter definitions support replacement of certain audit event fields, so that logged events contain the ...For ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
These terms are commonly used in information about the MySQL database server. These properties are all desirable in a database system, and are all closely tied to the notion of a transaction. When a transaction makes multiple changes to the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
DDL Options Usage scenarios for mysqldump include setting up an entire new MySQL instance (including database tables), and replacing data inside an existing instance with existing databases and tables. The mysqldump client utility performs logical ...The mysqldump command can also generate output in CSV, other delimited text, or XML ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...For information about character ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Drop the database first if you really want to replace an existing database, or add an IF NOT EXISTS clause to the CREATE DATABASE statement if to retain an existing database without having the statement produce an error. Error number: 1006; Symbol: ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
For josh, IDENTIFIED BY establishes a new password ('josh_new_password'), REPLACE is specified to verify that the user issuing the ALTER USER statement knows the current password ('josh_current_password'), and that current password is also retained ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Backing Up Your Database To avoid loss of data, always back up your database before trying to replace your MySQL installation using the MySQL APT repository. If you have installed MySQL with the MySQL Developer Zone's deb packages and now want to ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given name. To ...For information about character set and collation names, see Chapter 12, Character Sets, Collations, ...
https://dev.mysql.com/doc/refman/8.4/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 ...