MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 181 to 190 of 194 total results

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-column.html

isNumberSigned(): Indicates whether a numeric column is signed (true if it is signed). The Column object represents the column metadata in a result set. Column has the methods listed here: getFractionalDigits(): Gets the fractional digits of the ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html

Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html

In this case, comparison and sorting are based on numeric character code values. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/9.7/en/two-digit-years.html

For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/9.7/en/update.html

The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. To assign a hexadecimal or bit value as a number to a user variable, use it in numeric context. You can store a value in a ...

B.3.4.2 Problems Using DATE Columns

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/using-system-variables.html

The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...

8.4.4 The Password Validation Component

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

Displaying 181 to 190 of 194 total results