Mysql

In MySQL, the basic INSERT query syntax is:

Insert a single row
INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3);

Example:

INSERT INTO employees (id, name, age, department)
VALUES (1, 'John Doe', 30, 'IT');

Insert multiple rows
INSERT INTO employees (id, name, age, department)
VALUES
    (2, 'Alice', 25, 'HR'),
    (3, 'Bob', 28, 'Finance'),
    (4, 'Charlie', 35, 'Sales');
Insert into all columns

If you're providing values for every column in the correct order, you can omit the column names:

INSERT INTO employees
VALUES (5, 'David', 32, 'Marketing');

Insert data from another table
INSERT INTO employees_backup (id, name, age, department)
SELECT id, name, age, department
FROM employees
WHERE department = 'IT';