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.

• How to Use SQL JOIN to Retrieve Data from Multiple Tables

  Learn how to use advanced queries including join and subquery to retrieve data from multiple tables.

• « Previous page
• Next page »