PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
If named-pipe connections are not supported or if the user making the connection is not a member of the Windows group specified by the named_pipe_full_access_group system variable, an error occurs. If the server was not started with the named_pipe ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
Note When changing the total number of LCP threads or LQH threads per node group, you should recreate the schema from backup created using mysqldump. In NDB 7.5.2 and later, this step is necessary only if the total number of LCP threads or LQH ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
If a string return value should be in a different character set, convert it. The following example shows how to convert the result of gen_rnd_email() to the utf8mb4 character set: SET @email = CONVERT(gen_rnd_email() USING utf8mb4); It may also be ...