MySQL

MySQL Tutorials

MySQL is an open-source relational database management system (RDBMS).It is the world's most widely used RDBMS and with its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications.

Introduction to MySQL

In this tutorial you'll learn: What is a database? What is SQL? What is MySQL? Command prompt (CLI) and Graphical (GUI) MySQL Tools, and the usage of SHOW command.

Retrieving, Sorting and Filtering Data

You're about to experience the power of MySQL. You'll see how, you can retrieve data from MySQL database using SELECT, sort the retrieved data using ORDER BY and filter it with WHERE, LIKE, REGEXP etc...

Inserting, Updating and Deleting Data

INSERT is used to add single or multiple rows to a database table. Learn how to use INSERT in several ways:

Usage of ALTER TABLE to Modify the Table's Schema

ALTER Table is used to update the schema of an existing table. Using ALTER Table you can add and drop columns, make, update or delete relationships between tables using foreign key, add indexes and ...

Stored Procedures

Most of the SQL statements that we've used thus far are simple in that they use a single statement against one or more tables. Not all operations are that simple often, multiple statements will be needed to perform a complete operation...

Understanding Transaction Processing

Transaction processing is a mechanism used to manage sets of MySQL operations that must be executed in batches to ensure that databases never contain the results of partial operations...

Cursors

A cursor is a database query stored on the MySQL server not a SELECT statement, but the result set retrieved by that statement. Once the cursor is stored, applications can scroll or browse up and down through the data as needed...