When you create a database table, all the columns need to be assigned to a specific data type. The most common types include:
INT or INTEGER – integers
FLOAT or DOUBLE– floating-point numbers
Integer and floating-point numbers can be either signed (positive or negative) or unsigned (positive only).
MySQL does not have built-in Boolean type. However, it uses TINYINT(1) instead. MySQL provides BOOLEAN or BOOL as the synonym of TINYINT(1) for convenience.
Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
