|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
How can i delete the duplicate post ? Code: SELECT bad_rows. * FROM post AS bad_rows INNER JOIN ( SELECT threadid, dateline, username, userid, MIN( postid ) AS min_postid FROM post GROUP BY threadid, dateline, userid HAVING count( * ) >1 ) AS good_rows ON good_rows.threadid = bad_rows.threadid AND good_rows.dateline = bad_rows.dateline AND good_rows.userid = bad_rows.userid AND good_rows.min_postid bad_rows.postid Showing rows 0 - 29 (291,867 total, Query took 282.2048 sec) Attachment 43258 When i delete .... Code: Error SQL query: DELETE FROM `xxx_aaa`.`post` WHERE `bad_rows`.`postid` =384 MySQL said: #1054 - Unknown column 'bad_rows.postid' in 'where clause' Attachment 43259 http://www.vbulletin.com/forum/showthread.php?343419 __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |