MySQL: How to INSERT rows into a TABLE

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

[@ayskvv]

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

[@AayushGupta-fc8bi]

Thank You so much for telling MySQL so easily. I got full marks in practials.

[@Osebhahiemenn]

where did you practicalise?

[@bichoron3603]

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

[@murodjonsadullaev1727]

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

[@ArniSchofield]

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

[@mercenary5463]

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

[@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

[@blessing2457]

Thank you! This was helpful 👏🏽

[@j.kelvinfallah]

You killed it bro. Thanks

[@nicoschmid1]

Once again, thank you

[@kunalchauhan5294]

1 comment Felling lucky with every other bro

[@Wakeuptorealityman]

Ngl, ur cooking my man.🔥🔥

[@Person_Alive]

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

[@MalakJameel-x1h]

you are the best thank you so much

[@On7thSky]

I have a question, so how would I update the row once I have the information for the missing columns?

[@robertodhiambo6148]

Very helpful

[@sumanth1846]

THANK TOU SO MUCH BRO💌

[@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🧐

[@dinushachathuranga7657]

Thanks for the video❤

[@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.

[@ugyenofficial]

Thank you so much Bro❤❤

[@i.am_khai]

so what if i created a table myself in the sql and i wanted to import a csv.file into that table that i had just created. how could I do that?

[@younessj4923]

Thank you so much Broo

[@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

[@tboleon]

question, whats mysql and what is its purpose?

[@BroCodez]

It's a language to query a database

[@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

[@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

[@kennethfortugaleza5073]

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

[@KrAyOnS1]

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

[@TENREAL]

Just use INT

[@ArimuMariam]

Use INT

[@suryad3092]

in last how to add the records in remaining two columns

[@mdomine245]

is there commit or rollback command like oracle?

[@andredubbs4854]

cool video bro!

[@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

[@gamePlays9699]

Eugene?

[@short-shots]

BRO CHAD GANG GANG BOOM

[@ReeshavGhosh200]

How to make ai for games in html using javascript

[@M4LAZE]

how to remove dupicate rows

[@MACALINK]

Is this lecture university level or below?

[@mulumbacephas5036]

A random comment to hack youtube algorithm

[@Gametimewithsurya]

Bro is Bro

[@mohaymenul-islam]

✅ 8th October - 2024

[@fyrukmcoo100]

:((

[@BroCodez]

:))

[@UttejBobby]

****SINGLE QUOTATION MARKS ARE ENOUGH INSERT INTO employees VALUES (1, 'Eugene', 'Krabs', 25.50, '2023-01-02'); SELECT * FROM employees3; 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 employees3; -- EXAMPLE 3 -- INSERT INTO employees3 (employee_id, first_name, last_name) VALUES (6, 'Sheldon', 'Plankton'); SELECT * FROM employees3 order by employee_id

[@ronf6900]

NO GO TUTORIAL @brocode WTF

[@BroCodez]

y tho?