Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Quote Show Create Enabled If set to 1 (the default), the server quotes identifiers for SHOW CREATE TABLE and SHOW CREATE DATABASE statements. Buffer Result Enabled If set to 1, sql_buffer_result forces results from SELECT statements to be put into ... Lists the Statement Processing configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...The format of the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#. This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET.
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8mb3 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses.
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
For information about how the optimizer handles subqueries, see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. All subquery forms and operations that the SQL standard requires are ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...This may also be true for the names of built-in ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-internal-error.html
The index needs to be dropped and recreated NDB error code 914 MySQL error DMEC Error message Invalid index stats request NDB error code 916 MySQL error DMEC Error message Invalid index stats sys tables NDB error code 917 MySQL error DMEC Error ...