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 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

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

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

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

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

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

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

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

Building of Database
Building of Database

After you have planned your database, you can then build it. A database has two parts

  1. Structure to hold the data
  2. Data

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

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. MySQL is a component of the LAMP open-source web application software stack. LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python".

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

Using Database
Using Database

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

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

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 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:

  1. % : The percent sign represents zero, one, or multiple characters.
  2. _ : The underscore represents a single character.

Read More