Primary SQL Data Types for the Course

 

Major MySQL Datatypes

 

You can use the Sample Database form the MySQL Tutorial Website to practice the activities illustrated in the links below.  

Here is a Link to Download the My SQL Tutorial Sample Database

Download mysqlsampledatabase-1.sql

 

 

For Variable Length Text Data Use VARCHAR

http://www.mysqltutorial.org/mysql-varchar/ Links to an external site.

 

 

For Fixed Length Text Data Use CHAR

http://www.mysqltutorial.org/mysql-char-data-type/ Links to an external site.

 

 

To Store Integer Data, Use the INT Data Type

http://www.mysqltutorial.org/mysql-int/ Links to an external site.

 

 

To Store Floating Point Data, Use the Double Data Type

http://www.mysqltutorial.org/mysql-decimal/ Links to an external site.

 

 

 To Store Boolean Data, Use the BOOLEAN Data Type

http://www.mysqltutorial.org/mysql-boolean/ Links to an external site.

 

 

 

To Store Date Data, Use the DATE Data Type

http://www.mysqltutorial.org/mysql-date/ Links to an external site.

 

 

TO Store Time Data, Use the TIME Data Type

http://www.mysqltutorial.org/mysql-time/ Links to an external site.

 

 

TO Store both Date and Time Data in one attribute, Use the DATETIME Data Type

http://www.mysqltutorial.org/mysql-datetime/ Links to an external site.

 

 

To Store the Date and Time of a Database System Event use the TIMESTAMP Data Type

http://www.mysqltutorial.org/mysql-timestamp.aspx Links to an external site.