PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-index-types.html
If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. If you do not define a PRIMARY KEY for a table, InnoDB uses the first UNIQUE index with all key columns defined as NOT NULL ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-files-table.html
FILES columns that are not relevant to InnoDB always return NULL, and are excluded from the query. row *************************** FILE_ID: 0 FILE_NAME: ./ibdata1 FILE_TYPE: TABLESPACE TABLESPACE_NAME: innodb_system FREE_EXTENTS: 0 TOTAL_EXTENTS: 12 ... The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
The default value is NULL, which does not permit activating redo log archiving. subdir can be empty, null, or it can be left out. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-isolation-levels.html
Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of ...
https://dev.mysql.com/doc/refman/9.7/en/insert-on-duplicate.html
The VALUES() function is meaningful only as an introducer for INSERT statement value lists, or in the ON DUPLICATE KEY UPDATE clause of an INSERT statement, and returns NULL otherwise. If you specify an ON DUPLICATE KEY UPDATE clause and a row to ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-functions-plugin-specific.html
Return value: Returns 1 for success, or NULL and an error for failure. Return value: Returns 1 for success, or NULL and an error for failure. For each keyring plugin-specific function, this section describes its purpose, calling sequence, and ...
https://dev.mysql.com/doc/refman/9.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/load-data-local-security.html
Interpretation of the MYSQL_OPT_LOAD_DATA_LOCAL_DIR value is as follows: If the value is the null pointer (the default), it names no directory, with the result that no files are permitted for LOCAL data loading. mysql uses the option value to set ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...