Please enable JavaScript.
Coggle requires JavaScript to display documents.
Comand advanced of MySQL - Coggle Diagram
Comand advanced of MySQL
Finding elements with AND, OR, NOT, IN, LIKE, DISTINCT
-
-
-
comand with IN
SELECT * FROM name_table WHERE colomn_name IN ("value", 'value');
-
-
-
Grouping the out
SUM, MAX, MIN, AVG, COUNT
grouping with SUM -- SELECT column_name, SUM(column_name) AS new_column_name FROM table_name GROUP BY column_name;
grouping with MAX -- SELECT column_name, MAX(column_name) AS new_column_name FROM table_name GROUP BY column_name;
grouping with COUNT -- SELECT column_name, COUNT(*) AS new_column_name FROM table_name GROUP BY column_name;
grouping with MIN -- SELECT column_name, MIN(column_name) AS new_column_name FROM table_name GROUP BY column_name;
-
CASE, WHEN,THEN, ELSE, END
Structure
SELEC column_name, CASE WHEN column_name + condition THEN 'VALUE' WHEN column_name + condition THEN 'VALUE' ELSE 'VALUE' END AS column_new_name FROM table_name;
JOIN
INNER JOIN
SELECT A.column_name, B.conlumn_name FROM Table-Lift A INNER JOIN Table_Right B ON A.ID = B.ID
LEFT JOIN
SELECT A.column_name, B.column_name FROM table_lift A LEFT JOIN table_right B ON A.ID = B.ID
RIGHT JOIN
SELECT A.column_name, B.column_name FROM table_lift A RIGHT JOIN table_right B ON A.ID = B.ID
FULL JOIN
SELECT table_name.column_name FROM table_name LEFT JOIN table_name ON table_name.column_name = table_name.column_name UNION SELECT table _name.column_name FROM table_name RIGHT JOIN table_name ON table_name.column_name = table_name.column_name
CROSS JOIN
SELECT A.column_name, B.column_name FROM table_lift A, table_right B
-
-
Sub-consultas
-
SELECT X.column_name, X.column_new_name FROM (SELECT column_name, MAX(column_name)AS column_new_name FROM table_name GROUP BY column_name) X WHERE X.column_new_name > 10;
VIEWS
CREATE VIEW new_view SELECT column_name, MAX(column_name)AS column_new_name FROM table_name
GROUP BY column_name
SELECT X.column_name, X.column_name FROM VW_NAME
X WHERE X.column_name > 10;
-