MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 711 to 720 of 724 total results

2.8.10 Generating MySQL Doxygen Documentation Content

https://dev.mysql.com/doc/refman/8.0/en/source-installation-doxygen.html

When you install PlantUML on Windows (tested on Windows 10), you must run it at least once as administrator so it creates the registry keys. The MySQL source code contains internal documentation written using Doxygen. It is also possible to ...

15.5 Prepared Statements

https://dev.mysql.com/doc/refman/8.0/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, ...

27.8 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html

Restrictions for Triggers For triggers, the following additional restrictions apply: Triggers are not activated by foreign key actions. Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...

30.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html

Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...

10.15.2 System Variables Controlling Tracing

https://dev.mysql.com/doc/refman/8.0/en/system-variables-controlling-tracing.html

end_markers_in_json: If set to 1, causes the trace to repeat the key (if present) near the closing bracket. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: ...

15.2.16 TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/table.html

TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit ...

3.6 Preparing Your Installation for Upgrade

https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

To make a partitioned table nonpartitioned, execute this statement: ALTER TABLE table_name REMOVE PARTITIONING; Some keywords may be reserved in MySQL 8.0 that were not reserved previously. There must be no tables that have foreign key constraint ...

10.8.1 Optimizing Queries with EXPLAIN

https://dev.mysql.com/doc/refman/8.0/en/using-explain.html

If you have a problem with indexes not being used when you believe that they should be, run ANALYZE TABLE to update table statistics, such as cardinality of keys, that can affect the choices the optimizer makes. The EXPLAIN statement provides ...

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html

To use multiple-instance capability, modify the my.cnf option file to include configuration of key options for each instance. If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by ...

15.2.19 VALUES Statement

https://dev.mysql.com/doc/refman/8.0/en/values.html

VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] value_list: value[, value][, ...] column_designator: column_index The VALUES statement consists of the VALUES ...

Displaying 711 to 720 of 724 total results