MySQL: How to INSERT rows into a TABLE

#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;

[@BroCodez]

-- 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;

[@mercenary5463]

Bro called her sandy cheeks and thought we wouldn’t notice 😂

[@blessing2457]

Thank you! This was helpful 👏🏽

[@j.kelvinfallah]

You killed it bro. Thanks

[@ayskvv]

bro has helped me more than my teachers ever could :skull:

[@Kabila.Shabab-ok9fl]

Bro you made me cry, you're too good to make such a thought thing into an easy thing. LoL bro Lol

[@murodjonsadullaev1727]

thank you bro for sharing with such precious knowledges. God bless you man

[@dinushachathuranga7657]

Thanks for the video❤

[@ugyenofficial]

Thank you so much Bro❤❤

[@bichoron3603]

Amazing work Bro. Please keep it up & give us more tutorials about SQL learning & practical projects. Waiting for your replay

[@younessj4923]

Thank you so much Broo

[@user-wt4bb8fw5z]

Bro is a goat in this field, keep it up
🇿🇼🇿🇼🇿🇼

[@user-je1wn9um3i]

you are the best thank you so much

[@kunalchauhan5294]

1 comment Felling lucky with every other bro

[@andredubbs4854]

cool video bro!

[@lofwyr5063]

Is the fact that you are getting column names on the empty set a feature of the sql workbench? Cause all I get, on an empty set, is "empty set".
I'd have to use "show columns" for that.

[@Person_Alive]

Why and how, only 31 comments bro you deserve a lot more

[@mdomine245]

is there commit or rollback command like oracle?

[@adedamolayusuf7018]

trying to learn python although, your videos help a lot, I get bored after some time of learning like I need the thing I know to use for real-life problems what can I do

[@short-shots]

BRO CHAD GANG GANG BOOM

[@luly6465]

How can I delete a duplicate row?
When I follow the query example and it says: values ( and write I write the information of the employee) and then I run the query and check the table the row repeats🧐

[@kennethfortugaleza5073]

My man how do I add an image to a table? and if so anyway to view it?

[@tboleon]

question, whats mysql and what is its purpose?

[@BroCodez]

It's a language to query a database

[@gamePlays9699]

Eugene?

[@KrAyOnS1]

Question. You set the hourly pay to DECIMAL. What if it was a whole number woulf it matter?

[@TENREAL]

Just use INT

[@user-qh3lb8ft6x]

Use INT

[@ReeshavGhosh200]

How to make ai for games in html using javascript

[@essammakia3475]

im getting this error
17:57:10 INSERT INTO employees VALUES (1, "Eugene", "Krabs", 25, "2023-01-02") Error Code: 1136. Column count doesn't match value count at row 1 0.000 sec
hope you can help me !

[@brandonh9142]

my problem was i left the email section in check to make sure you have the correct amount of columns use code:
alter table employees
drop column email;
to remove a column.
then add the code again should work.

[@essammakia3475]

@@brandonh9142 thanks 🙏 I will give it a try

[@KrAyOnS1]

@@essammakia3475 Did it work? Having same issue

[@essammakia3475]

@@KrAyOnS1 no it did not work for me sadly

[@M4LAZE]

how to remove dupicate rows

[@mulumbacephas5036]

A random comment to hack youtube algorithm

[@sherzod7788]

hey bro code. at 5:09 can we just insert null values instead of telling mysql which columns we will insert?

[@markocoly4960]

hey did you find the solution i have the same problem

[@GaBeKool]

Something doesnt work for me. When i try to print the table (SELECT * FROM employees) my whole program crashes. Whats wrong there? Am i the only one having this issue?

[@jaylenharris2891]

did you ever figure out what was happening

[@GaBeKool]

Actually no

[@fyrukmcoo100]

:((

[@BroCodez]

:))

[@ronf6900]

NO GO TUTORIAL @brocode WTF

[@BroCodez]

y tho?