Hi, could someone help me with multiple records?
I have some table with multiple records, want to delete multiple records from this table by having unique records stay again in it.
I need to do it by using a SQL query, NOT a PHP or other language script.
I know the keyword distinct in MySQL, but it returns me back only this unique records, but i need to show the other part of records.
Thanks for answer. Bonoman.
So you have a table that has rows that have duplicate values in some columns, but different values in other columns? If that is the case, you need to decide which of the rows you want to keep, and the syntax needed to isolate either the rows you want to either keep or delete.
Once you've got that figured out, you should be able to put them together to create a DELETE statement that will do just what you want!
Just FYI, this sounds suspiciously like an assignment. You probably want to talk this out in person with somebody in the lab sessions rather than just ask for a solution on the internet.