Database - StackHowTo

Home » Database » Page 6

MySQL NATURAL JOIN

In SQL, the NATURAL JOIN statement allows making a natural join between two tables. This join is performed under the

In SQL, SELF JOIN is a join of a table with itself. This type of query is not so common

In the SQL language, the FULL JOIN (or FULL OUTER JOIN) command allows making a join between two tables. The

In the SQL language, the RIGHT JOIN command (also called RIGHT OUTER JOIN) is a type of join between 2

In the SQL language, the LEFT JOIN command (also called LEFT OUTER JOIN) is a type of join between 2

In the SQL language, the CROSS JOIN statement is a type of join on 2 SQL tables that allows returning

The AUTO_INCREMENT command is used in the SQL language to specify that a numeric column with a primary key (PRIMARY

The UNION ALL command in SQL is very similar to the UNION command. It allows you to concatenate the records

The GROUP BY statement is used in SQL to group multiple results and use functions on the grouping. WITH ROLLUP

A “wildcard” character is used to substitute for any other character in a string. These wildcards are used in the