» MySQL Tips

MySQL Tips

MySQL Copy Database Table

In this tutorial, you will learn how to copy data from one table into a new table by using SQL CREATE TABLE and SELECT statement.

Select Random Records in Database Table

In this tip, you will learn various techniques to select random items from a database table in MySQL.

Using Regular Expression in MySQL

MySQL built-in supports regular expression which allows you to search for text by using special operator call REGEX.

Count Records in a Database Table in MySQL

In this tutorial you will learn how to count record in a database table.

Select the nth Highest Record in a Database Table using MySQL

In this tutorial, you will learn how to the nth highest record in a database table in various techniques.

Compare Two Tables to Find Unmatched Records

In this tutorial, you will learn how to compare two tables to find unmatched records.

Avoid Displaying NULL Values by Mapping to Other Values

You will deal with how to avoid display NULL value by mapping to other values.

SQL Concatenate Functions in MySQL

In this tutorial you will learn various ways to concatenate two or more than two strings together by using CONCAT function which is provided by MySQL.