MySQL: How to INSERT rows into a TABLE

Published: 11 October 2022
on channel: Bro Code
116,186
1.6k

#mysql

-- EXAMPLE 1 --
INSERT INTO employees
VALUES (1, "Eugene", "Krabs", 25.50, "2023-01-02");
SELECT * FROM employees;

-- EXAMPLE 2 --
INSERT INTO employees
VALUES (2, "Squidward", "Tentacles", 15.00, "2023-01-03"),
(3, "Spongebob", "Squarepants", 12.50, "2023-01-04"),
(4, "Patrick", "Star", 12.50, "2023-01-05"),
(5, "Sandy", "Cheeks", 17.25, "2023-01-06");
SELECT * FROM employees;

-- EXAMPLE 3 --
INSERT INTO employees (employee_id, first_name, last_name)
VALUES (6, "Sheldon", "Plankton");
SELECT * FROM employees;


On this page of the site you can watch the video online MySQL: How to INSERT rows into a TABLE with a duration of hours minute second in good quality, which was uploaded by the user Bro Code 11 October 2022, share the link with friends and acquaintances, this video has already been watched 116,186 times on youtube and it was liked by 1.6 thousand viewers. Enjoy your viewing!