MySQL FLOAT vs DEC: working with fraction and decimal [DEC]
So far we have covered many of of useful datatypes of MySQL. Some of them are integers, text, varchar and most importantly, date and time and date-time...
Series: MySQL DataTypes
We discuss about various datatypes associated with MySQL. You will need these datatypes to create table holding the kind of data you want (such as integers, float, datatime, text etc). All of the tutorials have detailed discussion with example database creation queries and screenshots.
MySQL: Working with date time arithmetic #Part 2.3.1
So, this is the second last part of the long awaited MySQL datetime series. Previously we have leant how to work with MySQL datetime datatypes and how to...
Automatically insert Current Date and Time in MySQL table #Part – 2.2
Previously we have discussed widely on the Date and Time datatypes of MySQL. Date and Time both are important to keep exact record of inserted data in a...
MySQL date and time DataTypes Overview: DATE, TIME, DATETIME, TIMESTAMP, YEAR & Zero Values #Part2.1
In our previous tutorial we have talked about several MySQL data types like CHAR, VARCHAR, INT, TEXT etc… Today we shall discuss the very important data type...
MySQL data types: CHAR, VARCHAR, INT, TEXT #Part-1
Previously, we have seen how to create and use database and tables from MySQL terminal. Now while creating a table, we have discussed briefly on datatypes....
