MySQL DELETE Tutorial in Hindi / Urdu
Вставка
- Опубліковано 7 вер 2024
- In this tutorial you will learn mysql delete command tutorial in Hindi, Urdu.You can learn how to delete data from data tables in database with SQL delete command in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php
dear sir i am using this
delete from personnel
where city ="a";
but getting below error
"you are using safe update mode tried to update table with out Where"
I'm also facing the same problem.
delete from personnel
where city ="a%";
Yes go to edit that is at top of SQL workbench then to preferences click on SQL editor then uncheck safeupdates (reject update and delete with no key) finally click okay ..this will resolve this issue
sir if i want insert a new row after creating table and after deleting any value i want correct id no for exmp if i delete id no. 3 then id will show 1,2,4 but i need it show 1,2,3,4 is there any method to correct the id no.
Hello Rahul, In actual life we don't show primary key column "id". If we use any programming language like PHP or Python or NodeJS with MySQL then we generate our own sequence number at a time of showing all table's data with in loop like for() loop, foreach() loop. So I suggest you don't care about the sequence of MySQL database table's row. Even their is no method to correct it.
Kamal Kar dia Bhai Apny, Zabardast Tutorial
Finally Sallu bhai left 😂😂😂😂
Ye bahut accha hua😆
@@siddhant2002 haha
😂😂
sir mere workbench main rollback column ko rollback nahi karta sir please batai koi error bhi show nahi karta
For future viewers, those who are getting error code:1175 ---> KINDLY GO TO edit -> preferences -> sql editor -> UNCHECK the Safe updates box --> Now restart the MySQL workbench.
If someone needs video answer -- ua-cam.com/video/A_ROAHutuEU/v-deo.html
Thankx this was saved me bro 🙂
Thanks brother.
delete from personal2 where gender = "F" 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.
According to this, I can't delete any row until I don't pass the column which is the primary key.
Instead of { delete from personal2 where gender = "F"; }, I also tried { delete from personal2 where id in(select id from personal2 where gender = "F"); }
Both are not working.
MySql version: 8.0.26
please help.
Disable the safe mode.
To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
@@YahooBaba Thanks for giving me your valuable time & to solve my problem.
Thanks a lot. 😊
Very good sir✔️✔️💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯💯
Sir please make a detail playlist on normalization and relations thanks sir
Nice
thank you for making awsome tutorials . i just want to know how many more videos are coming to complete mysql. Thanks in advance
Approximately 10 videos are remaining.
Thank you so much sir😊😊😊😊😊🙃🙃🙃🙃😇😇😇😇😇
Most welcome
Great job sir
Hello Bhai Aapka Video Acha hai Mza aa rha hai Thank you. Ek que tha jaise delete krne ke baad ID ka order disarrange ho jata hai like 1,2,5,7 aise to kya koi query hai jisse ye phr order me ho jaye mtlb 5 bn jaye 4 or 7 bn jaye 6.
Uske liye ALTER command hoti hai. Us par bhi maine already video banayi hue hai issi playlist mein.
@@YahooBaba ok bhai I'm watching your series it's help me alot thanks
Gooooood job bro...
Great Work Sir
Thanks
thanks_Sir💜
Nice sir
Hello sir, aap ek book ko publish karo khud, isi explaination ko points banao...PHP and MySql ❤👍
Nice Idea ....Thanks :)
how to delete specific column from existing table?
Use ALTER command
Sir there is no any good videos about normalization in all over Internet please I request make some unique list with good examples thanks in advance
Yes Sure :)
Sir mujhse
DELETE FROM personal ;
command nahi chal rahi hai error aa raha hai
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.
ye rahi vo error
I am facing same issues
I solved this issue
Whenever you have get this error
Then apply
Such type of syntax
Use database name;
Select from personal;
Delete from personal
Where is = 4;
@@interestingFact999 ua-cam.com/video/5bFxbwjN-Gk/v-deo.html
Ja ke dekh lo sayad doubt clear ho jaye
@@interestingFact999 uske bad yahi par continue kar lena bro
@@interestingFact999 nice
awesome
sir what is basic requirement for data analyst job ?means what languages i need to fulfill this job?
Python is the best language for Data Analyst
DROP TABLE `student`.`city` Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails .........sir ye error aa rahi he isko solve kese kru.
nice working...
sir I need a pdf book in urdu of your tutorials.
caN yoU ?
No friend I don't provide pdf book.
DELETE name FROM personals where id=4;
Is it valid??
Sir, your tutorials are awesome and very clear to understand, there is a request to you make a video tutorial series of WordPress in which we learn about theme development and most important is the plugin development. If you like my request please reply.
Hello, Thanks for appreciating my work. I have already noted a course on Wordpress Theme and Plugin development in my courses pipeline. It will comes after 3 Months.
@@YahooBaba can you send me the link where I can see the list of courses in your pipeline
Sir, for data analyst jod also need mysql along with python or only need python ?. I am from Pakistan
SQL+ python is compulsory
Sir while using update command it's showing me error that you are using safe update mode
Please check this error on Google
salman khan left the job the way you explain i thought he left the bollywood
Sir if I try to delete table than one error occurred that is "you r using safe update mode and you tried to update without where
Sir delete command work nahi kar raha
Please help
got to edit>preference>click sql editor>in the end uncheck safe mode and restart sql
@@alltechsimplified2134 true maine bhi kia its works thanks bro
Hii sir , I am doing practice of MySQL from your playlist and in this video I faced a doubt
After deleting a row in middle of the table , suppose I want to reset the id’s if remaining all rows serially then how can I do that
For example -if I delete row 3 then in the table I’d 3 is missing but I want the next id will take Id 3 and vice versa remaining (Auto adjustment)
Can you please guide me on this , Thanks
For that u have to use "ALTER" command. See that video in this same playlist.
sir, how to delete duplicate value and also how to save null values in table?
1) To find duplicate value we have to use any programming language like PHP, Python.
2) You can easily save Null value if you don't set "NOT NULL" constraint to any column.
@@YahooBaba thanks for reply sir what is basic requirement for data analyst job ?means what languages i need to fulfill this job?
what does safe update error means sir ?????????????????????????????????????
OR sir ROLLBACK bhi kam nahi kar raha hai koi error nahi aati hai par nhi koi kam nahi karta hai
sir data ko delete karte samay ek error aa rha hai you are using safe mode 1175 ye kya hai
1. click edit
2. click preferences
3. click sql editer
4. scroll karne ke baad me safe mode ko uncheck kare
or workbeanch ko of karke on kare or sarver ko bhi
Kya abhi bhi error aa rahi hai ... safe mode ko Uncheck karne ke baad bhi.
@@YahooBaba no sir
what is error code 1175?
are you fan of Salman khan?
salman khan company chor k ja chuka hai ..😂😂😂😂
Nice