…`), KEY `physmessage_id_index` (`physmessage_id`), KEY `physmessage_id_is_header_index` (`physmessage_id`,`is_header`), CONSTRAINT `dbmail_messageblks_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=602519 DEFAULT…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 22, 2007 By 15 Comments
… key, notid int) type=innodb; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql> create table c (id int primary key, fk int , foreign key (fk) references p(id) on delete CASCADE ) type=innodb; Query OK, 0 rows affected…
Comment: PHP Sessions - Files vs Database Based
March 28, 2007 By 38 Comments
I use same connection for sessions/data with InnoDB but before I register a shutdown function which explicitly rolls … though. I use a session table with a varchar primary key that PHP uses as the identifier but I was thinking… one and using that as a foreign key. I might need to prevent some sessions from being deleted for an extended period of…
