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 


Deprecated: html_entity_decode(): Passing null to parameter #1 ($string) of type string is deprecated in D:\webserver\www\vcampusbd_com_https\answers\column_answer_two.php on line 128
+ Report
Total Preview: 1039
Classify the MySQL datatypes.
Copyright © 2024. Powered by Intellect Software Ltd