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/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. The scope of a local variable is the BEGIN ... The variable can be referred to ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
For example: Figure 2.17 MySQL Package Installer Wizard: Temporary Root Password Note MySQL expires this temporary root password after the initial login and requires you to create a new password. The package is located inside a disk image (.dmg) ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). A multiple-column index can be considered a sorted array, the rows of which contain values that are created by concatenating the values of the indexed columns. For certain ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 5.7, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). Use the same technique as -r and -n, but create all the keys in parallel, ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
To create a default value section, simply add the word default to the section name. To configure them all, create an [ndbd default] section that contains a DataMemory line to specify the data memory size. To support NDB Cluster, you must to update ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. Some database objects such ...