Data Manipulation Statements

• SELECT
  • FROM Clause
  • WHERE Clause
  • GROUP BY … HAVING Clause
  • ORDER BY Clause
  • LIMIT Clause
  • Join Query
  • Subquery
  • VALUES
  • FOR UPDATE
• Hierarchical Query
  • START WITH Clause
  • CONNECT BY Clause
  • Hierarchical Query Execution
  • Pseudo Columns for Hierarchical Query
  • Operators for Hierarchical Query
  • Functions for Hierarchical Query
  • Examples of Hierarchical Query
  • Performance of Hierarchical Query
• INSERT
  • INSERT … SELECT Statement
  • ON DUPLICATE KEY UPDATE Clause
• UPDATE
• REPLACE
• DELETE
• MERGE
• TRUNCATE
• PREPARED STATEMENT
  • PREPARE Statement
  • EXECUTE Statement
  • DEALLOCATE PREPARE/DROP PREPARE Statements
• DO
• CTE
  • CTE column names
  • RECURSIVE clause
  • CTE Usage in DMLs and CREATE