INSERT DEFAULT VALUES

INSERT DEFAULT VALUES is a SQL statement in the DML Statements category. Inserts a row using only default values defined in the table schema. The syntax is INSERT INTO table_name DEFAULT VALUES;. It returns 1 row inserted. A typical example: CREATE TABLE audit_log ( id INT AUTO_INCREMENT PRIMARY KEY, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO audit_log DEFAULT VALUES; -- Inserts a row with all defaults: id=auto, created_at=NOW() A close relative is INSERT INTO, which inserts new rows into a table. A close relative is UPDATE, which modifies existing rows in a table. Always use WHERE to avoid updating all rows. A close relative is DELETE, which removes rows from a table. Always use WHERE to avoid deleting all rows. More about this category: Data Manipulation Language — INSERT, UPDATE, DELETE, REPLACE, MERGE. Related DML Statements entries: INSERT INTO, UPDATE, DELETE, REPLACE INTO, INSERT ... ON DUPLICATE KEY UPDATE, MERGE, INSERT INTO SELECT, UPSERT (PostgreSQL).