MySQL Tutorial Data Types 106 codes

  1. Home
  2. MySQL Tutorial
  3. Data Types
1 A double quotation inside a string quoted with single quotation needs no special treatment
2 A inside a string quoted with may be written as
3 A single quotation inside a string quoted with double quotation needs no special treatment
4 All CHAR and VARCHAR values in MySQL are compared without regard to any trailing spaces
5 BIGINT[(M)] [UNSIGNED] [ZEROFILL]
6 BIT type column
7 BIT_COUNT(N)
8 Bit Functions
9 Bit-Field Values
10 Bitwise AND(&)
11 Bitwise OR()
12 Bitwise XOR(^)
13 BLOB column
14 BOOL, BOOLEAN
15 CHAR and VARCHAR
16 Character or String Data Types
17 Compare date column
18 Convert a string or a number to a string in hexadecimal format with the HEX() function
19 Data type mapping occurs at table creation time, after which the original type specifications are discarded
20 Date Datatypes
21 Date-related Data Types
22 DATETIME
23 DECIMAL(7,2)
24 DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
25 Differences between CHAR and VARCHAR
26 DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
27 ENUM Type
28 ENUM with default value
29 FLOAT(p) [UNSIGNED] [ZEROFILL]
30 FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
31 For floating-point values, results are inexact
32 For inserts into a DECIMAL or integer column
33 Four-digit year
34 FULLTEXT
35 Hexadecimal Values
36 How 0x00-padding of BINARY values affects column value comparisons
37 If a given value is stored into the CHAR(4) and VARCHAR(4) columns, the trailing spaces of values retrieved from the columns ar
38 If you retrieve an ENUM value in a numeric context, the column values index is returned
39 If you set a SET column to an unsupported value, the value is ignored and a warning is issued
40 In MySQL, 0 or NULL means false and anything else means true
41 Insert value to a YEAR type column
42 Insert value to SMALLINT column
43 Insert value to TINYINT column
44 Inserting data to ENUM type column
45 INT[(M)] [UNSIGNED] [ZEROFILL]
46 INTERVAL value Type
47 Invert all bits
48 Looking for an exact match in a set column
49 Looking for values containing the first set member
50 MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
51 MySQL recognizes the following escape sequences
52 Mysql SELECT MICROSECOND(2010-12-10 14
53 MySQL stores SET and ENUM as numbers
54 NULL means a missing unknown value
55 NULL values are presented first if you do ORDER BY ASC
56 NULL values are presented last if you do ORDER BY DESC
57 Numeric Types
58 Numeric Types Storage
59 Possible value for a ENUM column
60 Precede the quote character by an escape character ()
61 Search for SET values using the FIND_IN_SET() function
62 Search for SET values using the LIKE operator
63 SELECT 0x5162766c
64 SELECT 0xa+0
65 Set column default value for VARCHAR
66 SET column type
67 SET Type
68 Set up default value for SMALLINT
69 Shifts a number to the left ()
70 Shifts a number to the right
71 SMALLINT[(M)] [UNSIGNED] [ZEROFILL]
72 Storage Requirements for Date and Time Types
73 Storage Requirements for Numeric Types
74 String comparisons normally are case-insensitive
75 Strings
76 TEXT and BLOB
77 The basic datatypes
78 The default type of a hexadecimal value is a string
79 The format of the zero value for each type
80 The timestamp data type stores the time that a row was last changed
81 The values TRUE and FALSE are merely aliases for 1 and 0, respectively, as shown here
82 TIME
83 TIMESTAMP NULL DEFAULT 0000-00-00 00
84 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
85 TIMESTAMP NULL DEFAULT NULL
86 TINYINT[(M)] [UNSIGNED] [ZEROFILL]
87 To determine how many years served
88 To include quote characters within a string
89 Two NULL values are regarded as equal in a GROUP BY
90 Two-digit year
91 Use 0 and is not NULL
92 Use ENUM type column
93 Use numeric operation in ENUM type column
94 Use SMALLINT column as the primary key column
95 Use the IS NULL and IS NOT NULL operators for NULL value
96 Use Update statement to set a date column value
97 Using Data Types from Other Database Engines
98 Using if statement with BOOLEAN
99 Using the SET type
100 VARCHAR column with default value
101 When inserting binary data into a string column (such as a BLOB column), the following characters must be represented by escape
102 Working With Dates
103 YEAR
104 YEAR column type
105 You can include the NULL attribute in the definition of a TIMESTAMP column to allow the column to contain NULL values For examp
106 ZEROFILL,UNSIGNED,SERIAL,SERIAL DEFAULT VALUE