MySQL: How to UPDATE and DELETE data from a TABLE

[@BroCodez]

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

[@ognjenstevic8637]

I had a problem whit this, I got the following message: "Error Code: 1175. 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. 0.000 sec 15:41:22 UPDATE employees SET hourly pay = 10.25 WHERE employee_id = 6 Error Code: 1175. 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." That can be fixed by using the following sentence -> "SET SQL_SAFE_UPDATES = 0;". Have a nice day!

[@just-a-weeb4822]

Thank you bro🗿💪

[@gamerslog4135]

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!

[@samuraychik111]

update functioin is not working 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. 0.000 sec

[@vinalpawar7488]

Thanks 🙇‍♂

[@jenshardervingaardlarsen6180]

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. 😅

[@elliotradley4370]

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

[@anayasarintayn6568]

u really help alot! thanks to u im not failing in IT!

[@derman447]

Hey bro, love your videos ! I was wondering if you could make a tutorial series on OpenGL in C++, i know there's a lot of those on youtube but that would be really cool if it was explained by you. I don't mind if you can't, but that would be really appreciated.

[@rahulsaibanala8291]

daamn i just deleted all the rows 🤦‍♂, should have waited.

[@saimoomsikto9383]

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

[@BigMitchell1]

This helped my guy. Thanks!

[@ToughNevyHacSoc]

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

[@MeuTube]

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

[@recon6660]

love your contents always.

[@PanktiParmar-nt2rl]

If all hourly pay is changed to 10.25 then how to undo it so that we can get the original hourly pay of the employees

[@markkariuki8354]

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

[@elizataylor19]

Im a beginner , incidentally made null values in employee_id column for all, how do i replace them with number values. Thanks anyone who hleps

[@houdahammachi9240]

update fonction is not working SET SQL_SAFE_UPDATES = 0; disable safe update

[@cppandjavaandkotlindev]

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

[@computerengineercemberkcra3490]

You are a legend thanks

[@xudayfitechoffiaicl5125]

Thanks teacher

[@kamal9294]

Thank you bro

[@v4porwave803]

pov: how plankton villain arc started

[@MP-me5vl]

It does not work for me. I need help please

[@kaviyasekar2578]

Do a tutorial on Android studio using java pls

[@OliviaChen0806]

First Finally🎉

[@ahamedshathelegend1409]

for the algorithm #youtubevideos. #youtubemusic. #youtubechannel. #video. #live. #youtubecreator. #subscribe. #viral.

[@somethong_alone]

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

[@onenobu4945]

Tried this and I get ''invalid syntax near "WHERE"

[@cppandjavaandkotlindev]

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

[@emrebilen1395]

"alter table employees add primary key (userid)" use this for safe update error. But userid must include all unique and not null values.

[@IrfanKhan-bk8jy]

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.

[@mnsvn]

it literally says what to do in the error lol

[@MrGessio]

do what it says and then close and open again the mysql workbench

[@dhineshkumar2044]

go to edit -> preferences -> sql Editor -> lastly you see the dialog box for SAFE UPDATES(rejects UPDATEs AND DELETEs with no restrictions) -> unclick the dialog box close the mySQL workbench -> open the mySQL workbench again -> Run the code and it works simple

[@wolfethegamer8102]

@@dhineshkumar2044 Thank you this help so much!

[@dhineshkumar2044]

@@wolfethegamer8102 no worries bro

[@TranXuanDucPH]

23:08:34 UPDATE employees SET hourly_pay = 10.50 , hire_date = "2023-01-06" WHERE employee_id = 4 Error Code: 1175. 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. 0.000 sec

[@arsenart648]

you can use the: SET SQL_SAFE_UPDATES = 0; run it > do whatever cahnge you want BUT in the end of your work set it back to 1 since it is a useful safe barrier SET SQL_SAFE_UPDATES = 1;

[@jenis-01]

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

[@SaA-nm1op]

straight to the point . i love it

[@OpinionOfX]

Ravish kumar official

[@juneroyd.quinimon495]

Thank you it really helps me a lot!

[@lunivers2135]

thank you Bro Code😊

[@andredubbs4854]

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

[@Harzit]

Bro, you da best

[@amniat762]

i love bro code

[@muhammaddiymurodov9112]

hello bro code, your code is not working! from c lessons (string functions) ; #include #include int main(){ char string1[] = "Bro"; char string2[] = "Code"; strlwr(string1); // converts a string to lowercase //strupr(string1); // converts a string to uppercase //strcat(string1, string2); // appends string2 to end of string1 //strncat(string1, string2, 1); // appends n characters from string2 to string1 //strcpy(string1, string2); // copy string2 to string1 //strncpy(string1, string2, 2); // copy n characters of string2 to string1 //strset(string1, '?'); //sets all characters of a string to a given character //strnset(string1, 'x', 1); //sets first n characters of a string to a given character //strrev(string1); //reverses a string //int result = strlen(string1); // returns string length as int //int result = strcmp(string1, string2); // string compare all characters //int result = strncmp(string1, string2, 1); // string compare n characters //int result = strcmpi(string1, string1); // string compare all (ignore case) //int result = strnicmp(string1, string1, 1); // string compare n characters (ignore case) printf("%s", string1); /* if(result == 0) { printf("These strings are the same"); } else { printf("These strings are not the same"); } */ return 0; } it says: strlwr(string1); // converts a string to lowercase | ^~~~~~ | strstr stringFucntions.c:6:9: warning: unused variable 'string2' [-Wunused-variable] 6 | char string2[] = "Code"; | ^~~~~~~ pls help