· 6 years ago · Sep 03, 2019, 03:02 PM
1CREATE TABLE IF NOT EXISTS table_name (
2 id INT NOT NULL AUTO_INCREMENT,
3
4 -- Numeric Data Types
5 num1 INT,
6 num2 TINYINT,
7 num3 SMALLINT,
8 num4 MEDIUMINT,
9 num5 BIGINT,
10 num6 FLOAT(10,2),
11 num7 DOUBLE(16,4),
12 num8 DECIMAL(5,5),
13
14 -- Date and Time Types
15 date1 DATE,
16 date2 DATETIME,
17 date3 TIMESTAMP,
18 date4 TIME,
19 date5 YEAR(4),
20
21 -- String Types
22 string1 CHAR(255),
23 string2 VARCHAR(255),
24 string3a TEXT,
25 string3b BLOB,
26 string4a TINYTEXT,
27 string4b TINYBLOB,
28 string5a MEDIUMTEXT,
29 string5b MEDIUMBLOB,
30 string6a LONGTEXT,
31 string6b LONGBLOB,
32 string7 ENUM,
33
34 PRIMARY KEY (id)
35) ENGINE=INNODB;