MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 31 to 40 of 59 total results

24.3.31 The INFORMATION_SCHEMA VIEWS Table

https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html

For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in your queries. If you then create a view that concatenates items, you might worry that changing the ...

13.7.5.27 SHOW PROCEDURE CODE Statement

https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html

SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...

21.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-blob-tool.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as ...

21.5.7 ndb_config — Extract NDB Cluster Configuration Information

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). This tool extracts current configuration information for data nodes, SQL nodes, and API nodes ...

21.5.10 ndb_desc — Describe NDB Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c ...

21.5.12 ndb_drop_table — Drop an NDB Table

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ...

5.1.10 Server SQL Modes

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

ANSI Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, and (as of MySQL 5.7.5) ONLY_FULL_GROUP_BY. ER_BAD_NULL_ERROR ER_CUT_VALUE_GROUP_CONCAT ER_DATA_TOO_LONG ER_DATETIME_FUNCTION_OVERFLOW ER_DIVISION_BY_ZERO ... The MySQL ...

13.5 Prepared Statements

https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html

Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...

12.11 XML Functions

https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html

Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...

23.1 Defining Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html

Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...

Displaying 31 to 40 of 59 total results