MySQL Tutorial
MySQL is an RDBMS (Relational DataBase Management System).
MySQL is based on SQL (Structured Query Language). It is one of the most popular and most used Open Source RDBMS and works on most of the system platforms.
Tutorials
MySQL Table Basics
- MySQL – Create Table
- MySQL – Rename Table
- MySQL – Insert row into table
- MySQL – Select rows from table
- MySQL – Update a row in table
- MySQL – Delete a row in table
- MySQL – Delete all rows in table
- MySQL – Drop table
MySQL Table Advanced Tutorials
- MySQL – Add a new column to table
- MySQL – Add a column to index
- MySQL – Add an AUTO_INCREMENT column as PRIMARY KEY
- MySQL – Count number of rows in table
- MySQL – Delete only single row in table based on a condition
- MySQL – Delete or drop a column in table
- MySQL – Delete or drop a column from index
- MySQL – Delete rows in table where column is NULL
- MySQL – Duplicate Table
- MySQL – Increase column size
- MySQL – Insert multiple rows into table in a single statement
- MySQL – Limit number of rows
- MySQL – Rename column in table
- MySQL – Replace string in column
- MySQL – Select distinct values in column
- MySQL – Select rows from table based on condition
- MySQL – Show index of table
- MySQL – Update to current timestamp when row is updated
- MySQL – Update a column value for all rows in table
- MySQL – Update empty string values of a column in table