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_DO
miss OR which values do not return any tuple.
Perhaps this would be what you're looking for?
"SELECT fieldname,COUNT(*) FROM tablename WHERE fieldname IN
('aaa','bbb','ccc','ddd') GROUP BY fieldname;"
--
Fayaz Yusuf Khan
Cloud developer a
Hello all
Does MySQL 5 conform to Codd's rule 8, i.e. physical data independence,
which says that:
*Applications should not be logicaly impaired when the physical storage or
access ethods change.*
Any help would be greatly appreciated.
Thanks