PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Important For users familiar with the ANSI/ISO SQL Standard, please note that no storage engine, including InnoDB, recognizes or enforces the MATCH clause used in referential integrity constraint definitions. | {FULLTEXT | SPATIAL} [INDEX | KEY] ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
Global information, that is, the connection ID and user/host and where relevant the query string, is provided at key levels (connection-start, command-start, query-start, and query-exec-start). Additional Resources For more information on DTrace and ... Support for DTrace is deprecated in MySQL 5.7 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
See X DevAPI User Guide for in-depth tutorials on using X DevAPI. This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional ...
https://dev.mysql.com/doc/refman/5.7/en/execute.html
If the prepared statement contains any parameter markers, you must supply a USING clause that lists user variables containing the values to be bound to the parameters. Parameter values can be supplied only by user variables, and the USING clause ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an internal optimizer object with no user significance. For SELECT statements, the EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for INFORMATION_SCHEMA? See the MySQL User Forums. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find the ANSI SQL 2003 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for MySQL Views? See the MySQL User Forums. What happens to a view if an underlying table is dropped or renamed? A.6.4. Can you insert into views that are based on ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...