PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. While the server ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
In this Manual, we use dashes in option names, except where underscores are significant. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as --password. This ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ...To do so, you need to remove your old ... Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
Type "Mysql Release Engineering" into the search box and press Search. An import dialog is displayed; choose Okay, and this certificate should now be listed under the Imported Certificates tab. This requires files for both the packaged file, and the ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
There are some exceptions to this behavior for InnoDB tables, as discussed in Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”. In this case, reuse of values deleted from the top of the sequence occurs even for MyISAM tables. This affects ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of Unix. The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. The following statement would not work on Unix, because it refers to the alias both as a and as A: mysql> SELECT col_name FROM tbl_name AS a WHERE a.col_name = 1 OR A.col_name = 2; However, this same statement is permitted on ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text processing. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ ... The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB ...