Database - StackHowTo

Home » Database » Page 8

OR Operator in MySQL

In this tutorial, we are going to see how to use the OR operator in MySQL. The OR operator combines

In this tutorial, we are going to see how to check if a column is null, to achieve this we

REPLACE() function in MySQL replaces all occurrences of a substring in a string. Example 1: In the example below,

The statement INSERT INTO SELECT copies data from one table and inserts it into another table. The source and target

When you use the INSERT statement to add multiple rows to a table and if an error occurs during processing,

In this tutorial, we are going to see how to use MySQL INSERT ON DUPLICATE KEY UPDATE statement to update

MySQL has added support for derived tables (also called subqueries). In very simple terms, a derived table is a virtual

In this tutorial, we are going to see how to insert multiple rows in MySQL at a time. To insert

In this tutorial, we are going to see how to use the MySQL UNION operator to combine two or more

LIMIT keyword is used to limit the number of rows returned in the result of a query. It can be