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/source-configuration-options.html
You can build a plugin as a static module (compiled into the server) or a dynamic module (built as a dynamic library that must be installed into the server using the INSTALL PLUGIN statement or the --plugin-load option before it can be used). The ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. MySQL permits you to store certain incorrect date values into DATE and DATETIME columns (such as '2000-02-31' or '2000-02-00'). If you try ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Where can I find translations of the MySQL Manual into Chinese, Japanese, and Korean? A.11.19. Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. mysql> SET sql_mode = ''; ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
GET DIAGNOSTICS can obtain either statement or condition information, but not both in the same statement: To obtain statement information, retrieve the desired statement items into target variables. This instance of GET DIAGNOSTICS assigns the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. When InnoDB reads a page into the buffer pool, it initially inserts it at the midpoint (the head of the old sublist). By ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
For example, SELECT c1 FROM t WHERE c1 BETWEEN 10 and 20 FOR UPDATE; prevents other transactions from inserting a value of 15 into column t.c1, whether or not there was already any such value in the column, because the gaps between all existing ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ... SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, ...[ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} assignment: col_name = value assignment_list: assignment [, assignment] ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...