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