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;

Watch video MySQL: How to INSERT rows into a TABLE online without registration, duration hours minute second in high quality. This video was added by user Bro Code 11 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 116,186 once and liked it 1.6 thousand people.

14,567

205