MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 301 to 310 of 311 total results

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

On the other hand, with SET you can assign a variable's value using an expression, which is not true when you set a variable at server startup. The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server ...

2.5.9 Managing MySQL Server with systemd

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

To suppress this automatic initialization behavior, specify the following line in the /etc/sysconfig/mysql file (create the file if it does not exist): NO_INIT=true Configuring Multiple MySQL Instances Using systemd This section describes how to ...

8.4.4.2 Password Validation Options and Variables

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

Assuming that is true, each substring of the password of length 4 up to 100 is compared to the words in the dictionary file. This section describes the system and status variables that validate_password provides to enable its operation to be ...

8.4.4 The Password Validation Component

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

This is true even if an account is locked initially because otherwise unlocking the account later would cause it to become accessible without a password that satisfies the policy. The validate_password component serves to improve security by ...

27.6.3 Updatable and Insertable Views

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

The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. 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 ...

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 ...

2.3.3.2 Creating an Option File

https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html

This is particularly true under the following circumstances: The installation or data directory locations are different from the default locations (C:\Program Files\MySQL\MySQL Server 9.7 and C:\Program Files\MySQL\MySQL Server 9.7\data). If you ...

2.3.5 Windows Postinstallation Procedures

https://dev.mysql.com/doc/refman/9.7/en/windows-postinstallation.html

If that is not true, adjust the command path names accordingly. GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL server. If necessary, initialize the data directory ...

5.3.4.6 Working with NULL Values

https://dev.mysql.com/doc/refman/9.7/en/working-with-null.html

In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...

15.3.8.3 Restrictions on XA Transactions

https://dev.mysql.com/doc/refman/9.7/en/xa-restrictions.html

The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. XA transaction support is limited to the InnoDB storage engine. For “external XA,” ...

Displaying 301 to 310 of 311 total results