MySQL: How to INSERT rows into a TABLE
#mysql
-- EXAMPLE 1 --
INSERT INTO employees
VALUES (1, “Eugene“, “Krabs“, , “2023-01-02“);
SELECT * FROM employees;
-- EXAMPLE 2 --
INSERT INTO employees
VALUES (2, “Squidward“, “Tentacles“, , “2023-01-03“),
(3, “Spongebob“, “Squarepants“, , “2023-01-04“),
(4, “Patrick“, “Star“, , “2023-01-05“),
(5, “Sandy“, “Cheeks“, , “2023-01-06“);
SELECT * FROM employees;
-- EXAMPLE 3 --
INSERT INTO employees (employee_id, first_name, last_name)
VALUES (6, “Sheldon“, “Plankton“);
SELECT * FROM employees;