Mysql cheatsheet -

BIT(1-64)

Very small integer
Value(-128 to 127)

Very small integer
Value(0 - 255)

the values TRUE and FALSE are merely aliases for 1 and 0

Small integer
Value(-32768 to 32767)

Small integer
Value(0 - 65535)

Medium-sized integer
Value(-8388608 to 8388607)

Medium-sized integer
Value(0 - 16777215)

Normal-size integer
Value(-2147483648 to 2147483647)

Normal-size integer
Value(0 - 4294967295)

The synonym for "INT"

Large integer
Value(-2^63 to 2^63-1)

Large integer
Value(0 - 2^64-1)

Alias for "BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE"

DECIMAL[(M[,D])],
M(0 to 65digits),
D(0 to 30digits)

The synonym for "DECIMAL"

The synonym for "DECIMAL"

Value(-3.402823466E+38 to -1.175494351E-38),
( 0 ),
(1.175494351E-38 to 3.402823466E+38)

FLOAT(0-23) =>"4-byte single-precision FLOAT column",
FLOAT(24-53) =>" 8-byte double-precision DOUBLE column"

Value(-1.7976931348623157E+308 to -2.2250738585072014E-308),
( 0 ),
( 2.2250738585072014E-308 to 1.7976931348623157E+308)

SHOW DATABASES;

USE database_name;

SHOW TABLES;

DESCRIBE table;(desc table_name)

CREATE DATABASE db_name;

CREATE TABLE table_name (field1_name TYPE(size), field2_name TYPE(size));

LOAD DATA LOCAL INFILE "data.txt" INTO TABLE table_name;

INSERT INTO table_name VALUES ('name', 'age', 'dep');

SELECT from_columns FROM table_name WHERE conditions;

UPDATE table_name SET column_name = "new_value" WHERE field_name = "value"

SELECT field1, field2 FROM table_name ORDER BY field2

SELECT COUNT(*) FROM table_name

SELECT dept, COUNT(*) FROM tbl_name GROUP BY dept;