Inaccurate return value from DELETE query

INTO People (friday_id, parent_id) values (1,1), (2,1); DELETE FROM People; Output: Query OK, 1 row affected Shouldn't this be 2 rows affected? MySQL version 5.1 -- Fayaz Yusuf Khan Cloud developer and architect Dexetra SS, Bangalore, India fayaz.yusuf.khan_AT_gmail_DOT_com fayaz_AT_dexetra_DOT_com

Re: How to find values which do not return any tuple in IN clause

for? SELECT fieldname,COUNT(*) FROM tablename WHERE fieldname IN ('aaa','bbb','ccc','ddd') GROUP BY fieldname; -- Fayaz Yusuf Khan Cloud developer and designer in Python/AppEngine platform Dexetra Software Solutions Pvt. Ltd., Kochi, Kerala, India B.Tech. Computer Science Engineering (2007-2011