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...
Category: MySQL
Tutorials related to MySQL
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...
Create Login Admin & Logout Page in PHP w/ SESSION n MySQL
This post has been outdated. Please check the new one here where we have discussed how to create the system using session and cookie with remember me option....
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....
How to create DataBase and Table in MySQL
This is the first of our Learn MySQL Tutorial. In this post we shall learn how to create and use Databases and tables in MySQL using MySQL terminal. In case...
How to Connect to XAMPP/MySQL using Windows CMD [Command Prompt]
On our previous post, we have discussed about how to install LAMP Environment on your Windows PC easily using XAMPP. If you are a MySQL coder, or wish to...
