PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Create_options shows the ENCRYPTION option specified when creating or altering a file-per-table tablespace. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. Create_options shows the row format that was specified in the CREATE TABLE ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). FULLTEXT indexes cannot be created on a column that uses any of these character ...The ucs2, utf16, utf16le, and utf32 character sets have the following restrictions: None of them can be used as the client character ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
(Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style comments. MySQL Server supports three comment styles: From a # character to the end of ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an ...