More »
Loading...

Resource

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

String

String Comparison

Regular Expressions

Numeric

Arithmetic Operators

Date

Group

Information

Encrypt

Miscellaneous

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