MySQL Data Types

Great day Everyone, This tutorial is all about MySQL Data Types. I will tell you and teach you all you need to know about the MySQL Data Types. As a programmer you need to know every kinds of data types so let’s get started:

MySQL supports a number of SQL data types in several categories: numeric types, date and time types, string (character and byte) types and spatial types. This tutorial provides an overview of these data types, a more detailed description of the properties of the types in each category, and a summary of the data type storage requirements.

Data types comes in several forma and sizes, allowing the programmer to create tables suited to the scope of the project.

Data Type Description
CHAR(size) This type is used to store character strings values of fixed length. The size in brackets determines  the number of characters the cell can hold. The maximum number of character(i.e the size) this data type can hold is 255 characters. Ex- EmployeName CHAR(100)
VARHAR(size) This data type is used to store variable length alphanumeric data. It is more flexible from of the CHAR data. VARCHAR can hold 1 to 255 characters. CHAR is much faster than VARCHAR sometimes up to 50%.
INT The INT data type used to store number. An Integer – 2147483648 to 2147483647.
DECIMAL A long double-precision floating point number.
DOUBLE A long double-precision floating point number
DATE A Date in YYYY-MM-DD format.
TIME A time in the HH:MM:SS format.
DATETIME A Combined date and time in the format YYYY-MM-DD HH:MM:SS
TIMESTAMP Automatic date and time of last record entry
TEXT A String upto 65535 characters long.
BLOB A binary type for variable data.

 

That’s it! I hope you learn something today about MySQL Data Types

If you have any comments or suggestions about MySQL Data Types Please message us Directly:

Other Articles you might read also:

 

Leave a Comment