I have a table and I want to delete all rows with a specific card serial . There are multiple rows with the same card serial .So I wrote this code but it seems that's not working:
how can assure all the rows will be deleted . Should I use procedure? How do I use procedure?