Sir,when i am applying this command why it is showing error for delete duplicate entry method which you apply first delete from emp where emp_id in(select emp_id from ( select *,row_number() over(partition by name,age,salary order by emp_id) as row_num from emp ) as table1 where row_num>1); this error is coming 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.016 sec
Hi akash, This error is because MySQL safeupdate setting is on. Safeupdate restricts certain types of queries that can unintentionally affect a large number of rows while deletion. And, using a WHERE clause with condition on a non-key column (that can have repeated values) could be one cause of that. What can you do? For now, you can turn the setting off in Edit->Preferences->SQL Editor->Uncheck Safe Updates (you can find the checkbox at the bottom most position in the window). Then restart MySQL and try again. Your query should work. Let me know if you face any issues
Thanks Abhishek, they may ask these type of questions in data analytics interview. However, the idea is that you should be aware of different functions and options available in SQL and how they can be used for different applications. Some may ask more elaborate questions where you will have to join different tables and apply these functions for different requirements. This playlist is highly recommended but for sure not enough. If you want to solve more questions you can refer to www.hackerrank.com/domains/sql Hope it helps
thnks fr xplng wndws fnctins clearly , if possble cn u xpln any healthcare project
Very well explained, thanks for the videos.
Thanks. Glad it was helpful
Pls keep making these videos.
Feedback noted
Amazing video sir, Very informative❤❤❤,Its help me alot
Glad to hear that
@TheMLMine sir how can i connect with you over the Instagram.
Your efforts are highly appreciated 👍👍
Thank you 😊
Hello sir,
Please make detailed videos on
Python libraries
Pandas
Numpy
Matplotlib
Seaborn
Hello Jagdish, next video on matplotlib.. coming soon
Appreciated bro 👍🏻 is there any chance we get matplotlib after this series?
Sure bro, soon you will see a video on that as well 👍
Sir,when i am applying this command why it is showing error for delete duplicate entry method which you apply first
delete from emp
where emp_id in(select emp_id from (
select *,row_number() over(partition by name,age,salary order by emp_id) as row_num from emp
) as table1 where row_num>1);
this error is coming
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.016 sec
Hi akash,
This error is because MySQL safeupdate setting is on. Safeupdate restricts certain types of queries that can unintentionally affect a large number of rows while deletion. And, using a WHERE clause with condition on a non-key column (that can have repeated values) could be one cause of that.
What can you do? For now, you can turn the setting off in Edit->Preferences->SQL Editor->Uncheck Safe Updates (you can find the checkbox at the bottom most position in the window). Then restart MySQL and try again.
Your query should work.
Let me know if you face any issues
nice video are they ask these type of questions to fresher or not do they ask hard questions for data analytics
Thanks Abhishek, they may ask these type of questions in data analytics interview. However, the idea is that you should be aware of different functions and options available in SQL and how they can be used for different applications.
Some may ask more elaborate questions where you will have to join different tables and apply these functions for different requirements. This playlist is highly recommended but for sure not enough. If you want to solve more questions you can refer to www.hackerrank.com/domains/sql
Hope it helps