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/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
INTO OUTFILE do not overwrite existing files and are writable by everyone. When you connect to a MySQL server, you should use a password. Password handling during the client connection sequence was upgraded in MySQL 4.1.1 to be very secure. If you ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
MySQL Enterprise Data Masking and De-Identification functions enable masking existing data using several methods such as obfuscation (removing identifying characteristics), generation of formatted random data, and data replacement or substitution.
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being modified. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
If your shell is tcsh, add the following line to your .tcshrc file: setenv PATH ${PATH}:/usr/local/mysql/bin If the appropriate startup file does not exist in your home directory, create it with a text editor. Environment variables can be set at ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
Installing SHA-256 Pluggable Authentication The sha256_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. MySQL provides two ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. To name the account, ...