Hii Saloni !! While working with my SQL workbench, whenever I try to update my table details like set e_name = 'XYZ'.... its raising error like "You are using Safe Update Mode".... How to fix this ???
You need to specific the where condition to update e_name at multiple position while using safe mode, to update the same first run the following query : SET SQL_SAFE_UPDATRS = 0; Then you can run your update query
This series is very useful. Thanks !!
Thank you for this very useful video!
Precise context😀
I'm always enjoying your lectures... Keep it up
Mam, you are doing a great work. Please create windows function video. Thank you so much for your amazing work ❤😊
Hii Saloni !! While working with my SQL workbench, whenever I try to update my table details like set e_name = 'XYZ'.... its raising error like "You are using Safe Update Mode".... How to fix this ???
You need to specific the where condition to update e_name at multiple position while using safe mode, to update the same first run the following query : SET SQL_SAFE_UPDATRS = 0;
Then you can run your update query
OUTPUT-TRIM LEADING 456, TRIM TRAILING http: is that possible to trim only 0 or / ???
how to show more than duration 1000:00:00 in MySQL?
SELECT id, RIGHT(dob,2) As result FROM employee;
result
output--- 19
10
12
03
10
17
09
28
26
Right Answer. 👍
Where is ' Search ' function??
859:59:59 only showing
in my Mysql