on p1.name=p2.name
where p1.price = 0 and p2.price>0;
=
I am able to get the update statements properly,
but unfortunately my table(no single rows)
was not updated really.
I am using mysql 3.22.32.
am i doing anything
on p1.name=p2.name
where p1.price = 0 and p2.price>0;
=
I am able to get the update statements properly,
but unfortunately my table(no single rows)
was not updated really.
I am using mysql 3.22.32.
am i doing anything
Hi all,
Is there anyway to delete the duplicate records in mysql
without creating new tables. I am wondering what query
will achieve this task where mysql doesnt supports like ROWID and sub queries.
I appreciate if some one help me out.
thankyou.
-malkova