Sintax MySQL

SELECT / VIEW

• SELECT column1, column2, ...
• FROM table_name;

INSERT INTO

• INSERT INTO table_name (column1, column2, column3, ...)
• VALUES (value1, value2, value3, ...);

EDIT/UPDATE

• UPDATE table_name
• SET column1 = value1, column2 = value2, ...
• WHERE condition;

DELETE

• DELETE FROM table_name WHERE condition;

SELECT DISTINCT (tampilkan data unik)

• SELECT DISTINCT column1, column2, ...              
• FROM table_name;

INNER JOIN

• SELECT table1.OrderID, table2.CustomerName , table.CustomerPhone
• FROM table1
• INNER JOIN table2 ON table2.CustomerID = table1.CustomerID;
• INNER JOIN table3 ON table3.CustomerID = table1.CustomerID;