On 2/9/2012 8:58 AM, Reindl Harald wrote:
Am 09.02.2012 14:55, schrieb william drescher:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
so explain the
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
I think it's because of the constraint that you've defined on the table. So
that the record with friday_id=1 won't be deleted because of the constraint.
Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
-Original Message-
From: Fayaz Yusuf Khan