Prev: functions and global variables
Next: help using phpadmin
From: Shreyas Agasthya on 20 Jul 2010 07:06
I am very keen to see a closure to this thread so that I can add to my
snippets.
Let's all know what worked best out of many solutions that have been
proposed.

--Shreyas

On Tue, Jul 20, 2010 at 10:07 AM, Jim Lucas <lists(a)cmsws.com> wrote:

> Peter wrote:
>
>> Hi All,
>>
>> I have a table which contain's some duplicate rows. I just want to delete
>> the duplicate records alone
>> not original records.
>>
>> Assume my table as look as below
>>
>> column1 column2
>> 1
>> a
>> 1
>> a
>> 2
>> b
>> 3
>> c
>> 3
>> c
>>
>>
>>
>> i want the above table need to be as below, After executing the mysql
>> query.
>>
>> column1
>> column2
>> 1
>> a
>> 2
>> b
>> 3
>> c
>>
>>
>>
>>
>> Thanks in advance..
>>
>> Regards
>> Peter
>>
>>
> Use the SQL command alter with the ignore flag.
>
> ALTER IGNORE TABLE `your_table` ADD UNIQUE ( `column1` , `column2` )
>
> I tested this on my test DB and it worked fine. It erased all the
> duplicates and left one instance of the multiple entry values.
>
> This will add a permanent unique restraint to the table. So, you will
> never have dupps again.
>
> Jim Lucas
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
Regards,
Shreyas Agasthya
First  |  Prev  | 
Pages: 1 2 3
Prev: functions and global variables
Next: help using phpadmin