Tag

mysql Archives - Crazy Education

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

SQL Injection

By | MYSQL, Programming | No Comments

An SQL Injection can destroy your database. SQL in Web Pages In the previous chapters, you have learned to retrieve (and update) database data, using SQL. When SQL is used to display data on a web page, it is common to let web users input their own search values. Since…

Read More