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 of MySQL tables. It is Date and Time. There are various forms of date-time data types. It becomes very much important to learn each of them as date and time are the unique identity for each of your records. In this Part of Data Types (2.1) we shall see the available date time data...

So do you own a business website and want to get some profit from that? If yes, then the first thing you should consider is getting proper visitors. Now a days people don’t remember the website they want. They just simply search! Be it Google, Bing or Yahoo, all the search engines are now delivering more than 50% of the total traffic to any average web-site. Hence, being a web master, the first we need to do is Optimize our site for...

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. Datatypes are necessary to define the types of data inside every column. They can be simple Characters, text, integer or others. MySQL comes with plenty of datatypes to work with. Defining them properly will not only stop you from entering wrong data, but also will save space on your...

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 you don’t know about running MySQL terminal, check this post to learn. Databases are main objects in MySQL. Every data is stored inside Databases. But it can not be stored directly inside it! Tables are used to store Related Data inside a Database. So basically, whenever we wish to...

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 learn it, then probably you have came to know about the MySQL terminal [or simply a command prompt in Windows]. Basically it is the best MySQL tool for any newbie user. You have type all your SQL Queries here manually and this way you can actually learn faster. But opening the MySQL...

 So far we have talked much about Web-Development. But one thing we were missing is how to make a LAMP (Linux Apache MySQL PHP) environment in our Windows PC. If you are a Linux user, then you should be able to host your PHP scripts and MySQL Databases easily as mostly all Linux Distros come with LAMP preinstalled on it! But installing Apache, PHP and MySQL manually on your Windows Environment can be really hectic. Also you can not...