MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 451 to 456 of 456 total results

« Previous
44
45
46
Next »

30.4.5.18 The quote_identifier() Function

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

Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. 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

Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...

B.3.4.2 Problems Using DATE Columns

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

You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...

7.6.6.4 Version Tokens Reference

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

The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several functions. One set of functions ...

2.3.1 MySQL Installation Layout on Microsoft Windows

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

For MySQL 8.0 on Windows, the default installation directory is C:\Program Files\MySQL\MySQL Server 8.0 for installations performed with MySQL Installer. If you use the ZIP archive method to install MySQL, you may prefer to install in C:\mysql. All ...

13.2.4 The YEAR Type

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

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