Mysql Tutorial
Learn Mysql interactively. Read the concept and write code to practice.
1. MySQL Introduction
MySQL is a widely used Relational Database Management System (RDBMS). MySQL is f...
2. MySQL Create Database
To do anything with MySQL, you first need a database. The `CREATE DATABASE` sta...
3. MySQL Create Table
The `CREATE TABLE` statement is used to create a new table in a database. Synta...
4. MySQL Constraints
SQL constraints are used to specify rules for data in a table. They limit the ty...
5. MySQL Auto Increment
Auto-increment allows a unique number to be generated automatically when a new r...
6. MySQL Insert Multiple Rows
It is possible to insert multiple rows into a table using a single `INSERT` stat...
7. MySQL Update Data
The `UPDATE` statement is used to modify the existing records in a table. Synta...
8. MySQL Delete Data
The `DELETE` statement is used to delete existing records in a table. Syntax: `...
9. MySQL LIMIT Clause
The `LIMIT` clause is used to specify the number of records to return. The `LIM...
10. MySQL LIKE & Wildcards
The `LIKE` operator is used in a `WHERE` clause to search for a specified patter...
11. MySQL GROUP BY
The `GROUP BY` statement groups rows that have the same values into summary rows...
12. MySQL Joins (INNER JOIN)
A `JOIN` clause is used to combine rows from two or more tables, based on a rela...