Month: November 2009

In this section of the mysql training course we will explore the MySQL commands to create database tables and […]

Now that we've created our employee_data table, let's check its listing. Type SHOW TABLES; at the mysql prompt. This […]

Inserting data into tables The INSERT SQL statement impregnates our table with data. Here is a general form of […]

Our employee_data table now contains enough data for us to work with. Let us see how we can extract […]

In this section of the MySQL tutorial we'll look at the format of a SELECT statement we met in […]

We will now learn at how to match text patterns using the where clause and the LIKE operator in […]

In this section of the SQL primer we look at how to select data based on certain conditions presented […]

This section of the tutorial MySQL looks at the In and BETWEEN operators. To list employees who are Web […]

This section of the MySQL primer looks at how we can change the display order of the data extracted […]

This section of the MySQL primer looks at how to limit the number of records displayed by the SELECT […]