Mysql

MySQL Data Type

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

Data TypeDescription
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%.
INTThe INT data type used to store number. An Integer – 2147483648 to 2147483647.
DECIMALA long double-precision floating point number.
DOUBLEA long double-precision floating point number
DATEA Date in YYYY-MM-DD format.
TIMEA time in the HH:MM:SS format.
DATETIMEA Combined date and time in the format YYYY-MM-DD HH:MM:SS
TIMESTAMPAutomatic date and time of last record entry
TEXTA String upto 65535 characters long.
BLOBA binary type for variable data.

The DECIMAL data type  parameter specify the total number of permissible digits and the number of digits that may follow the decimal point  not the number of permissible digits for the decimal point’s left side and right side.
e.g : DECIMAL(5,2) permits -999.99 to 999.99

 

Recommended Tutorials for you


Related posts

MySQL Users

Anuj Kumar

MySQLi Procedural Functions

Anuj Kumar

MySQL Insert Into

Anuj Kumar

MySQL Command-line

Anuj Kumar

MySQL GUI Tools

Anuj Kumar

MySQL Column Modifiers

Anuj Kumar

MySQL Select Query

Anuj Kumar

MySQL PHP Connections

Anuj Kumar

How to Connect php with mysql Database

Anuj Kumar

Leave a Comment

* By using this form you agree with the storage and handling of your data by this website.

This site uses Akismet to reduce spam. Learn how your comment data is processed.