Amending the already uploaded database entries!

[tasmeem]

hi,
i hav uploaded the sql file to store the values in mysql db, but unfortunately some values are saved twice or more than once. there is no promary or forigen key in db...but ther is unique value in evry row by which i can spot those entries out. should i use php or sql to delete the repeated rows?

 

[BabyJeffy]

You should use sql.

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094

 

[tasmeem]

can u teme sample code?

 

[BabyJeffy]

Here is the basic SQL for deleting something:

DELETE FROM [COLOR=red]name_of_your_table[/color] WHERE ([COLOR=red]name_of_unique_field[/color]=[COLOR=red]a_unique_number_to_match[/color]) LIMIT 1;

All this - and more, at the mySQL Online Manual (free for all to read).

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094

 

[jpadie]

another useful example of the non-ansi LIMIT function. it's almost enough to cause me to give up using abstraction layers!

 

[BabyJeffy]

Shhh... he'll lose marks for that

Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094