Because the openid and fakeid correspond to the fan data of the public platform with errors, you need to promptly clean up the wrong data captured in the database, the preceding SQL statement deletes the data that appears twice in the fakeid of a public account... because the openid and fakeid correspond to the fan data of the public platform with errors, you need to promptly clean up the wrong data captured in the database, the preceding SQL statement deletes the data that appears twice in the fakeid of a public account. The next time you interact, you can capture the data.
The following is an SQL statement used to delete error data. the code is as follows:
SELECT * FROM enet_wechatfans WHERE fakeid IN (SELECT fakeid FROM (select count (*) c, id, fakeid FROM 'enet _ wechatfans 'WHERE weid = 135 group by fakeid HAVING c> 1) AS tmp) AND weid = 135 // open source code phprm.com
Article address:
Reprint at will ^ please include the address of this article!
