472,103 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

Deleting duplicate entries from database table

Suppose a table "address" contains the following records

-------------------------------------------------------
| name | address | phone |
-------------------------------------------------------
| mr x | 8th lane | 124364 |
| mr x | 6th lane | 435783 |
| mrs x | 6th lane | 435783 |
| mr x | 8th lane | 124364 |
-------------------------------------------------------
>Execute single query (MySQL Version: No Restriction), with sub-query or some other method
>After executing the query
-------------------------------------------------------
| name | address | phone |
-------------------------------------------------------
| mr x | 8th lane | 124364 |
| mr x | 6th lane | 435783 |
| mrs x | 6th lane | 435783 |
-------------------------------------------------------
>Please suggest on this
Jul 7 '06 #1
0 1809

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Francesco Moi | last post: by
18 posts views Thread by Dan | last post: by
3 posts views Thread by andreas.maurer1971 | last post: by
3 posts views Thread by Nathan Bloom | last post: by
7 posts views Thread by php_mysql_beginer911 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.