mariadb-syntax-sql-dml

What problem does it solve?

This Skill ensures the creation of robust and efficient SQL DML (Data Manipulation Language) statements for MariaDB, addressing common pitfalls and enhancing data integrity.

Core Features & Use Cases

• Insert, Update, Delete, Replace: Offers deterministic patterns for DML operations, preventing silent data corruption.
• Upsert Management: Provides guidance on handling upsert operations with INSERT ... ON DUPLICATE KEY UPDATE and REPLACE INTO.
• Error Handling: Identifies and resolves common errors such as silent coercion, AUTO_INCREMENT burning, and undefined behavior in multi-table updates.
• Use Case: For a database administrator, this Skill helps in crafting correct INSERT statements to avoid data corruption, especially when migrating from MySQL to MariaDB.

Quick Start

Use the mariadb-syntax-sql-dml skill to generate a correct INSERT ... ON DUPLICATE KEY UPDATE statement for your inventory table.