SQL: Querying, Delete

  hello there to have me back for another video sql server today we're going to be covering the topic on deleting i have some code here pre-typed for you just gonna copy this in copy so we were doing last time now even though you can delete sometimes the link can be very frustrating so let's um and deadly too so select star from tester and we have all this we have two people with the last name bad wall and um rn and rt um so if we delete from tester where the last name is equal to battle just like what we when we were um uh selecting with where it will delete both the people now that's how it can be very bad because if um let's say you wanted to delete one customer from your table um and you just put in this first name many people might have that first name and then lots of people go down and you need to remake your database but a fix to that is to put some unique identification with that so i have 10 feedback sheet here delete that and then select it didn't delete every single back sheet it just deleted candy so um that was our deleting um tutorial for sql that was one of the shortest ones we've made thank you um like comment subscribe ask me if you have any questions goodbye