Loading...

Resource

Online

Download

Related

Data Types

Types

  • CHAR
  • String (0 - 255)
  • VARCHAR
  • String (0 - 255)
  • TINYTEXT
  • String (0 - 255)
  • TEXT
  • String (0 - 65535)
  • BLOB
  • String (0 - 65535)
  • MEDIUMTEXT
  • String (0 - 16777215)
  • MEDIUMBLOB
  • String (0 - 16777215)
  • LONGTEXT
  • String (0 - 429496-7295)
  • LONGBLOB
  • String (0 - 429496-7295)
  • TINYINT x
  • Integer (-128 to 127)
  • SMALLINT x
  • Integer (-32768 to 32767)
  • MEDIUMINT x
  • Integer (-8388608 to 8388607)
  • INT x
  • Integer (-2147-483648 to 214748-3647)
  • BIGINT x
  • Integer (-9223-372-036-854-775808 to 922337-203-685-477-5807)
  • FLOAT
  • Decimal (precise to 23 digits)
  • DOUBLE
  • Decimal (24 to 53 digits)
  • DECIMAL
  • "-DOU-BLE-" stored as string
  • DATE
  • YYYY-MM-DD
  • DATETIME
  • YYYY-MM-DD HH:MM:SS
  • TIMESTAMP
  • YYYYMM-DDH-HMMSS
  • TIME
  • HH:MM:SS
  • ENUM
  • One of preset options
  • SET
  • Selection of preset options

Operators

Assignment Operators

Logical Operators

Comparison Operators

String

String Comparison

Regular Expressions

String Functions

Numeric

Arithmetic Operators

Mathematical Functions

Date

Date and Time

Group

GROUP BY Functions

Information

Information Functions

Encrypt

Encryption and Compression

Miscellaneous

Miscellaneous Functions

Samples

Select Queires

  • Returns all columns
  • SELECT * FROM table
  • Returns all columns
  • SELECT * FROM table1, table2, ...
  • Returns specific column
  • SELECT field1, field2, ... FROM table1, table2, ...
  • Returns rows that match condition
  • SELECT ... FROM ... WHERE condition
  • Returns with orders
  • SELECT ... FROM ... WHERE condition GROUP BY field
  • Returns withd orders and match condition
  • SELECT ... FROM ... WHERE condition GROUP BY field HAVING condition2
  • Returns first 10 rows
  • SELECT ... FROM ... WHERE condition LIMIT 10
  • Returns with no repeats
  • SELECT DISTINCT field1 FROM ...
  • Returns and joind
  • SELECT ... FROM t1 JOIN t2 ON t1.id1 = t2.id2 WHERE condition

AltStyle によって変換されたページ (->オリジナル) /