Category: Category: MySQL

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 […]

In this section of the online MySQL guide, we will look at how to select and display records from […]

MySQL provides inbuilt functions to find the minimum and maximum values. SQL provides 5 aggregate functions. They are: MIN(): […]