--- Table structure for table `club_listing`CREATE TABLE IF NOT EXISTS `club_listing` (
`memberid` INT( 11 ) NOT NULL COMMENT 'foreignkey for members id说:文档
#1064 - You have an error in your SQL syntax; check the manual th
SELECT * FROM History INNER JOIN (SELECT MAX(id) as id FROM History GROUP BY home_id) last_updates ONlast_updates.id = History.id
结果,我得到了一组数据。UPDATE History SET status = '0' WHERE (SELECT * FROM History INNER JOIN (SELECT MAX(id) as <e