Greetings
I manage a website wherein i keep track of the people
email who have downloaded my software and the version
number.
the structure is like -
id int auto_increment primary key,
email char,
version
now the same person can download different version
therfore my table has data like this -
1,my***@mysql.com,1.0
2,my***@mysql.com,2.0
3,my***@mysql.com,3.0
Now I want to delete all the records wherein all rows
with duplicate email addresses are deleted so that i
have data like
1,my***@mysql.com,1.0
....
What should be the query? Thanks in advance.
Karam
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw