MySQL: How to UPDATE and DELETE data from a TABLE

UPDATE employees
SET hourly_pay = 10.25
WHERE employee_id = 6;
SELECT * FROM employees;

DELETE FROM employees
WHERE employee_id = 6;
SELECT * FROM employees;

This helped my guy. Thanks!

Great stuff, but why is Plankton only paid 10.50 and Sandy 17? He has experience running a fast food restaurant. As far as I know Sandy is just a scientist. 😅

It does not work for me. I need help please

why cant you use "modify" or "alter" to update or delete data?

Bro, you da best

Thank you it really helps me a lot!

Ravish kumar official

after deleting the data from the table how did u regain the data

If I just waited until the very end, I wouldn't have had to delete my entire TABLE and start again. I accidentally created 2 of the exact same because I did have the SELECT * FROM employees; after creating VALUE (3, "Me", "You", 50.00, "2020-02-28"); so I had 2 copies of it. Could not figure out how to delete it since I could not call on it since it had an exact copy.

If I waited, I could have only had to delete 2 rows instead of all 8.
Thank you for making these! Make's learning a hell of a lot easier. You're a life saver and a wizard!

Legit the greatest channel for tutorials, keep up the excellent work bro

Bro i'm getting error "You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect." while using the update command somebody please help.

You are a legend thanks

Hey bro, I'd be really really really appreciate if you create a video on how we can build an analog clock in java

Hello bro! Hope you are doing amazing. We are patiently waiting for a React course. Thanks in advance.

hey bro i wonder if you could do a rust full course i know theres other rust courses but they are ba and they skip to complex things so i wonder if you can make one

hey bro i wonder if you could do a rust full course i know theres other rust courses but they are ba and they skip to complex things so i wonder if you can make one

I want to delete full column .... Plzzzzz give a keyword or somthing

Thanks teacher

Do a tutorial on Android studio using java pls

Please can you make C++ Data structures video like for Java?? Please!!!!!!!!!! You explain so good

Thank you bro

love your contents always.

thank you Bro Code😊

hey bro, great video as per usual. thanks alot!

First Finally🎉