Home  • MySQL • Basic Short Question

Question: Classify the MySQL datatypes. 

Answer MySQL broken down datatypes in three broad categories: a) Date and time b) Numeric data types c) String data types a) Data types in Date and time  category: 1. DATE 2. DATETIME 3. TIME 4. TIMESTAMP 5. YEAR b) Data types in Numeric  category: 1. BOOL, BOOLEAN 2. BIGINT 3. INT 4. MEDIUMINT 5. SMALLINT 6. TINYINT 7. DECIMAL 8. DOUBLE 9. FLOAT ([M,D]) 10. FLOAT (precision) c) Data types in String category: 1. CHAR 2. VARCHAR 3. LONGBLOB 4. LONGTEXT 5. MEDIUMBLOB 6. MEDIUMTEXT 7. BLOB 8. TEXT 9.TINYBLOB 10. TINYTEXT 11. ENUM 12. SET 

+ Explanation
+ Report 
Total Preview: 280