MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 331 to 340 of 345 total results

https://dev.mysql.com/doc/refman/9.7/en/update.html

UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...

3.13 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/9.7/en/upgrade-troubleshooting.html

A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 9.7 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html

Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer ...

7.1.9 Using System Variables

https://dev.mysql.com/doc/refman/9.7/en/using-system-variables.html

The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/9.7/en/using-systemd.html

If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...

8.4.4.2 Password Validation Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/validate-password-options-variables.html

This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...

8.4.4 The Password Validation Component

https://dev.mysql.com/doc/refman/9.7/en/validate-password.html

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...

27.6.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

15.6.5.8 WHILE Statement

https://dev.mysql.com/doc/refman/9.7/en/while.html

[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...

Displaying 331 to 340 of 345 total results