Aliases are used to give a table, or a column in a table, a temporary name.
Aliases are often used to make column names more readable.
An alias only exists for the duration of that query.
An alias is created with the AS keyword. Continue reading MySQL Aliases
The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
The BETWEEN operator is inclusive: begin and end values are included. Continue reading MySQL BETWEEN Operator
The IN operator allows you to specify multiple values in a
WHERE
The IN operator is a shorthand for multiple
OR
A wildcard character is used to substitute one or more characters in a string.
Wildcard characters are used with the
LIKE operator is used in a
WHERE
The LIKE operator is used in a
WHERE
There are two wildcards often used in conjunction with the
LIKE
The percent sign and the underscore can also be used in combinations! Continue reading MySQL LIKE Operator
The COUNT() function returns the number of rows that matches a specified criterion.
SELECT COUNT(column_name) FROM table_name WHERE condition;
The AVG() function returns the average value of a numeric column. Continue reading MySQL COUNT(), AVG() and SUM() Functions
The MIN() function returns the smallest value of the selected column.
The MAX() function returns the largest value of the selected column. Continue reading MySQL MIN() and MAX() Functions
The LIMIT clause is used to specify the number of records to return.
The LIMIT clause is useful on large tables with thousands of records. Returning a large number of records can impact performance. Continue reading MySQL LIMIT Clause
The DELETE statement is used to delete existing records in a table.
DELETE FROM table_name WHERE condition;
Note: Be careful when deleting records in a table! Notice the
WHEREDELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted!
The UPDATE statement is used to modify the existing records in a table.
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
Note: Be careful when updating records in a table! Notice the
WHEREUPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!