Latest Tutorials

CSS3 module references

CSS3&n...

MySQL tutorial introduction

As information technology era started to grow and many industries went from manual to automated work; the need of storing large data and managing it efficiently arises. Hence, countering this need...

Creating and managing MySQL database

How to create Database? Creating a database is a first step in MySQL (or any other DB!). In MySQL you create a database by using CREATE DATABASE:...

Storage engines and table types in MySQL

Storage engines or table types in MySQL are used to define how a database

Numeric Data Types in MySQL

MySQL supports a variety of data types to support and store different kind of data and to perform different operations on it. Supported data types can be majorly catego...

String Data Types in MySQL

MySQL supports a variety of data types to support and store different kind of data and to perform different operations on it. Supported data types can be majorly catego...

Date and Time Data Types in MySQL

MySQL supports a variety of data types to support and store different kind of data and to perform different operations on it. Supported data types can be majorly catego...

Spatial Data Types in MySQL

MySQL supports a variety of data types to support and store different kind of data and to perform different operations on it. Supported data types can be majorly catego...

MySQL Tables

In databases, tables are the containers of information. There can be one or many tables in a database. They are also called entities. Columns with data in a table are called attributes...

Creating MySQL Table

To create a table in MySQL, a CREATE TABLE statement is used. This statement is very complex because it requires defining all columns, data types and other parameters that make a c...