MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 501 to 506 of 506 total results

« Previous
49
50
51
Next »

30.4.5.18 The quote_identifier() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-quote-identifier.html

This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. Example mysql> SELECT ...

30.4.4.25 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html

Use the format db_name.tbl_name or tbl_name without using any backtick (`) identifier-quoting characters. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure ...

B.3.4.2 Problems Using DATE Columns

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

“Relaxed” format means that any punctuation character may be used as the separator between parts. You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= ...

7.6.6.4 Version Tokens Reference

https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html

mysql> SELECT version_tokens_unlock(); +-------------------------+ | version_tokens_unlock() | +-------------------------+ | 1 | +-------------------------+ The locking functions share these characteristics: The return value is nonzero for success.

2.3.1 MySQL Installation Layout on Microsoft Windows

https://dev.mysql.com/doc/refman/8.0/en/windows-installation-layout.html

include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation Silent Installation Methods Use MySQL Installer, see Section ...

13.2.4 The YEAR Type

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

It can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display width. The YEAR type is a 1-byte type used to represent year values. Note As of MySQL 8.0.19, the YEAR(4) data type with ...