I'm working on a new series of queries that share a temporary table.
I've tried using both create temporary table select and create
temp table then insert into t ... select from y. Both seem to
create a lock that (if the select portion runs long enough) causes a
deadlock with the replication
Mike,
- Original Message -
From: Mike Debnam [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, November 21, 2004 9:25 PM
Subject: temporary tables, replication, and innodb tables
I'm working on a new series of queries that share a temporary table.
I've tried using both