PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL Server has a practical set of features developed in close cooperation with our users. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. The following table shows the available servers for Windows in MySQL 5.7. Binary ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation: All files with the following extensions: .BAK .DAT .HSH .MRG .MYD .MYI .TRG .TRN .cfg .db .frm ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". It is good practice to start the bootstrap member first, and let it create the group. Creating ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
This section explains how to create a replication group with three MySQL Server instances on one physical machine. Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
What is the group_replication_bootstrap_group option used for? The bootstrap flag instructs a member to create a group and act as the initial seed server. When the group is originally created, or when shutting down and restarting the entire group.