Home MySQL Reference INSERT

INSERT

command

Inserts new rows into a table. Can insert single or multiple rows in one statement.

Syntax

INSERT INTO table (col1, col2) VALUES (val1, val2);

Example

sql

-- Single row
INSERT INTO users (name, email, created_at)
VALUES ('Alice', 'alice@example.com', NOW());

-- Multiple rows
INSERT INTO users (name, email) VALUES
    ('Bob',     'bob@example.com'),
    ('Charlie',  'charlie@example.com'),
    ('Diana',    'diana@example.com');

-- Insert or ignore duplicate
INSERT IGNORE INTO tags (name) VALUES ('php');

SELECT

UPDATE