Re: Inaccurate return value from DELETE query

2012-02-11 Thread luckyx_cool_boy
Khan Date: Sat, 11 Feb 2012 22:03:45 To: Subject: Inaccurate return value from DELETE query CREATE TABLE `People` ( `friday_id` bigint(20) NOT NULL, `parent_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`friday_id`), KEY `parent_id` (`parent_id`), CONSTRAINT `People_ibfk_1` FOREIGN

Inaccurate return value from DELETE query

2012-02-11 Thread Fayaz Yusuf Khan
CREATE TABLE `People` ( `friday_id` bigint(20) NOT NULL, `parent_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`friday_id`), KEY `parent_id` (`parent_id`), CONSTRAINT `People_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `People` (`friday_id`) ON DELETE CASCADE ) ENGINE=InnoDB; INSERT INTO Pe