Introduction of MySQL


MySQL is a relational database management system.
In Relational Database Management System every database consists of one or more tables inside it. Thus you can say that a Database is a collection of one or more then one tables which are related with each other in one or another way.
A table in the Database is used to store records. The records in the table are organized in the form of rows. Each row in the table represents particular record.
A record that is contained in the table is a collection of one or more columns. Each column in the record represents field of specific type in the database table. Each field in the record contains values for the different records.
Thus you can say that a Database is a collection of tables, table is a collection of records and record is a collection of fields.
MySQL First released in January, 1998, MySQL is now one component of parent company MySQL AB's product line of database servers and development tools.
MySQL runs on virtually all platforms, including Linux, UNIX, and Windows.
It is fully multi-threaded using kernel threads, and provides application program interfaces (APIs) for many programming languages, including C, C++, Java, Perl, PHP, and Python.
MySQL is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications and distributed applications. It is also increasingly embedded in third-party software and other technologies.

     

MySQL DataTypes


MYSQL Data Types are divided into three main categories as given below:
(1) Numeric DataType
(2) String or Text DataType
(3) Date Time Data Type

Numeric DataType



Data Type SIZE  
TINYINT 1 It is used to store integer values.
SMALLINT 2 It is used to store integer values.
MEDIUMINT 3 It is used to store integer values.
INT 4 It is used to store integer values.
BIGINT 8 It is used to store integer values.
FLOAT 4 It is used to store single precision floating point value.
DOUBLE 8 It is used to store double precision floating point value.
DECIMAL  10 It is used to store decimal value.

String or Text Data Type



Data Type SIZE  
CHAR 255 It is used to store fixed length string.
VARCHAR 255 It is used to store variable length string.
TINYBLOB 255 It is used to store short binary data.
TINYTEXT 255 It is used to store short text string.
BLOB 65535 It is used to store large binary data.
TEXT 65535 It is used to store large text string.
MEDIUMBLOB 16777215 It is used to store medium binary data.
MEDIUMTEXT 16777215 It is used to store medium text string.
LONGBLOB 4294967295 It is used to store extremely large binary data.
LONGTEXT 4294967295 It is used to store extremely large text string.

Date Time Data Type



Data Type SIZE  
DATE 3 It is used to store date values in the YYYY-MM-DD format.
TIME 3 It is used to store time values or time duration in the HH:MM:SS format.
YEAR 1 It is used to store year values in the YYYY format.
DATETIME 8 It is used to store Date and Time value in the YYYY-MM-DD HH:MM:SS format.
TIMESTAMP 9 It is used to store combined date and time values in the YYYYMMDDHHMMSS format.

Download Projects


Download Programs