MySQL Tutorial

Many dynamic websites require a back-end database. The database can contain information that the web pages display to the user, or the purpose of the database might be to store information provided by the user. In some applications, the database both provides available information and stores new information.

How to Use LIKE Operator in SQL

How to Use LIKE Operator in SQL

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards used in conjunction with the LIKE operator.

Read More
Foreign Key in SQL

Foreign Key in SQL

Relational databases are categorized as they are because the data is stored in tables that are related to each other in some way. The relationship occurs because a row in one table may be directly related to one or more rows in another table.

Read More
Primary Key in SQL

Primary Key in SQL

The PRIMARY KEY uniquely identifies each record in a database table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only one primary key, which may consist of single or multiple fields.

Read More
History and Versions of MySQL

History and Versions of MySQL

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

Read More
How to Select From two Tables in MySQL

How to Select From two Tables in MySQL

In many cases, you often need to get data from multiple tables in a single query. You can use JOIN clause to get data from multiple tables in your single SQL query. A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

Read More
How to Select from One Table in SQL

How to Select from One Table in SQL

The SELECT statement is used to select data from a database. The data returned is stored in a result table. Because the SELECT statement inquires about the contents of a table, it is called a query.

Read More
Using Database

Using Database

A database needs to be able to receive information for storage and to deliver information on request.

Read More
How to Change Table Structure in MySQL

How to Change Table Structure in MySQL

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. It is also used to add and drop various constraints on an existing table.

Read More
How to Create Table in SQL

How to Create Table in SQL

The CREATE TABLE statement is used to create a new table in a database. The column specifies the name of the column of the table. The datatype parameter specifies the type of data the column can hold.

Read More
Building of Database

Building of Database

After you have planned your database, you can then build it. A database has two parts: (i) Structure to hold the data (ii) Data.

Read More
Data Types in MySQL

Data Types in MySQL

MySQL stores information in different formats. It allows different types of data to be used in different ways. The main types of data are character, numerical, and date and time. When you create a database, you tell MySQL what kind of data to expect in a particular column by using the MySQL names for data types.

Read More

Database Indexing

An index is an ordered (or indexed) subset of table columns, with each row entry pointing to its corresponding table row.

Read More
Designing of Database

Designing of Database

The first step in creating a database is to design it. You create the database and its tables according to the design you developed.

Read More
What is NULL in SQL

What is NULL in SQL

A field with a NULL value is a field with no value. If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field. Then, the field will be saved with a NULL value.

Read More
How to Delete Data using SQL

How to Delete Data using SQL

If much of that data consists of rows that you will probably never need to access again, it makes sense to get rid of it. The DELETE statement is used to delete existing records in a table.

Read More
How to Update Data using SQL

How to Update Data using SQL

The UPDATE statement is used to modify the existing records in a table. With an UPDATE statement, you can change a single row in a table, a set of rows that share one or more characteristics, or all the rows in the table.

Read More
How to Insert Data into Table

How to Insert Data into Table

The INSERT INTO statement is used to insert new records in a table.

Read More
SQL Statements

SQL Statements

SQL is almost like simple English. It is made up largely of English words, put together into strings of words that sound similar to English sentences.

Read More
Drop vs Truncate Table in SQL

Drop vs Truncate Table in SQL

The DROP TABLE statement is used to drop or completely delete an existing table in a database. Deleting a table will result in loss of complete information stored in the table.

Read More
Introduction to MySQL Database

Introduction to MySQL Database

The MySQL software consists of the MySQL server, several utility programs that assist in the administration of MySQL databases, and some supporting software that the MySQL server needs. The heart of the system is the MySQL server.

Read More
MySQL vs MariaDB

MySQL vs MariaDB

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Some of the original developers of MySQL forked it due to concerns over its acquisition by Oracle Corporation. Its lead developer is Michael "Monty" Widenius, one of the founders of MySQL AB. MariaDB is named after Monty's younger daughter Maria, similar to how MySQL is named after his other daughter My.

Read More
Database Normalization

Database Normalization

Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships.

Read More