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/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-c-api.html
What is “MySQL Native C API”? What are typical benefits and use cases? libmysql is a C-based API that you can use in C applications to connect with the MySQL database server. It is also itself used as the foundation for drivers for standard ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
Is there a way to view all triggers in a given database? A.5.7. Is there a way to view all triggers in a given database? Yes. You can obtain a listing of all triggers defined on database dbname using a query on the INFORMATION_SCHEMA.TRIGGERS table ...Where can I find the documentation for MySQL 5.7 triggers? ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH PRIVILEGES Re-reads the privileges from the grant tables in the mysql system database. FLUSH TABLES WITH READ LOCK Closes all open tables and locks all tables for all databases with a global read lock. For each table, InnoDB also produces a ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
A DROP DATABASE operation can drop tables that belong to a general tablespace but it cannot drop the tablespace, even if the DROP DATABASE operation drops all tables that belong to the tablespace. A general tablespace is a shared InnoDB tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the unqualified table name. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. REFERENCED_TABLE_SCHEMA The name of the schema (database) referenced by the constraint.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
TRIGGER_SCHEMA The name of the schema (database) to which the trigger belongs. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. DATABASE_COLLATION The collation of the database ...