Category

MYSQL

SQL Joins

By | MYSQL, Programming | No Comments

SQL joins are used to combine rows from two or more tables.  It is used to combine rows from two or more tables, based on a common field between them. The most common type of join is: SQL INNER JOIN (also know as simple join). An SQL INNER JOIN returns…

Read More

SQL Aliases

By | MYSQL, Programming | No Comments

SQL aliases are used to temporarily rename a table or a column heading. They are used to give a database table, or a column in a table, a temporary name. Basically aliases are created to make column names more readable. SQL Alias Syntax for Columns SQL Alias Syntax for Tables…

Read More

SQL BETWEEN Operator

By | MYSQL, Programming | No Comments

The BETWEEN operator is used to select values within a range. It selects values within a range. The values can be numbers, text, or dates. SQL BETWEEN Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Products” table: ProductID…

Read More

SQL IN Operator

By | MYSQL, Programming | No Comments

The IN operator allows you to specify multiple values in a WHERE clause. SQL IN Syntax Database Example In this tutorial we will use the well-known Northwind sample database. Below is a selection from the “Customers” table: CustomerID CustomerName City 1 Ekta Dehradun 2 Anu Mumbai 3 Sonal Haridwar 4…

Read More

SQL Wildcards

By | MYSQL, Programming | No Comments

In SQL wildcard character can be used to substitute for any other character(s) in a string.They are used with the SQL LIKE operator. SQL wildcards are used to search for data within a table. With SQL, the wildcards are: Wildcard Description % A substitute for zero or more characters _…

Read More