MySQL Tutorial

How to Load Sample Database into MySQL Database Server

Tue, 18 Oct 2011 18:22:03 GMT

In this tutorial, you will learn how to load Classic Models sample database into MySQL database server using SQLyog community edition.

MySQL DATEDIFF Function

Sun, 07 Aug 2011 19:57:48 GMT

In this tutorial, you will learn how to use MySQL DATEDIFF function to calculate number of days between two dates or datetimes

MySQL Prepared Statement

Sun, 07 Aug 2011 18:11:11 GMT

In this tutorial, you will learn how to use MySQL prepared statement to utilize binary protocol implemented since MySQL 4.1 to make your code more secure and faster.

MySQL LAST_INSERT_ID

Sun, 07 Aug 2011 18:07:12 GMT

In this tutorial, you will learn how to use MySQL LAST_INSERT_ID function to obtain last inserted ID of a record that contain an AUTO_INCREMENT column.

MySQL Transaction

Sun, 07 Aug 2011 17:55:49 GMT

In this tutorial, you’ll learn what MySQL transactions are and how to use MySQL COMMIT and MySQL ROLLBACK to manage transaction in MySQL.

MySQL IF Function

Mon, 09 May 2011 05:12:12 GMT

In this tutorial, you will learn how to use MySQL IF control flow function in your SQL statement.

MySQL INNER JOIN

Sat, 07 May 2011 04:13:15 GMT

In this tutorial, you will learn how to use MySQL INNER JOIN clause to select data from multiple tables based on join conditions.