MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 191 to 197 of 197 total results

« Previous
18
19
20
Next »

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

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 context and vice versa. You should use this format in UPDATE expressions and in the WHERE ...

17.6.1.1 Creating InnoDB Tables

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

With so many constraints, often there is not an obvious set of columns to use as a primary key, so you create a new column with a numeric ID to serve as all or part of the primary key. InnoDB tables are created using the CREATE TABLE statement; for ...

7.1.9 Using System Variables

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

When you use a startup option to set a variable that takes a numeric value, the value can be given with a suffix of K, M, or G (either uppercase or lowercase) to indicate a multiplier of 1024, 10242 or 10243; that is, units of kilobytes, megabytes, ... The MySQL server maintains many system variables that configure its ...

8.4.3 The Password Validation Component

https://dev.mysql.com/doc/refman/8.0/en/validate-password.html

MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character. The validate_password component serves to improve security by ...

22.5.5 Connection Compression with X Plugin

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html

In addition to agreeing on a compression algorithm for each connection, the server and client can agree on a compression level from the numeric range that applies to the agreed algorithm. From MySQL 8.0.19, X Plugin supports compression of messages ...

14.11 XML Functions

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

Check all user-submitted data for type; reject or convert data that is of the wrong type Test numeric data for out of range values; truncate, round, or reject values that are out of range. Table 14.16 XML Functions Name Description ExtractValue() ...

13.2.4 The YEAR Type

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

The result of inserting a numeric 0 has a display value of 0000 and an internal value of 0000. 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 ...