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/innodb-restrictions-limitations.html
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name 'db_row_id' SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
To see what plugins are installed, use the SHOW PLUGINS statement or query the INFORMATION_SCHEMA the PLUGINS table. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. It requires the INSERT privilege ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
Note The procedure shown here does not set up any passwords for MySQL accounts. Build the Distribution On Unix: $> make $> make VERBOSE=1 The second command sets VERBOSE to show the commands for each compiled source. To install MySQL from a ...
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html
The following table shows the required storage and range for each integer type. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
The SHOW COLUMNS and DESCRIBE statements use BLOB as the type for some columns, thus the temporary table used for the results is an on-disk table. In some cases, the server creates internal temporary tables while processing statements. The server ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program options. To invoke a MySQL program from the command line ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-brokers.html
The following example shows how to use Freenet6 as the broker and the gogoc IPv6 client package on Gentoo Linux. If you do not have a public IPv6 address that enables your system to communicate over IPv6 outside your local network, you can obtain ...