Inserting Data into MySQL Tables

Published July 26, 2025 By Sai Sree Ram Gundepudi

Basic Insert

INSERT INTO employees (id, name, salary)
VALUES (1, 'John Doe', 50000);

Multiple Rows

INSERT INTO employees (id, name, salary)
VALUES
  (2, 'Jane Smith', 60000),
  (3, 'Alice Lee', 70000);

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article