hi,
I'm using mysql-5.1.22, innodb. For some reason, I need to add some
columns to a table without locking it, so I do this:
insert into TABLE2(col1, col2, ... ,colN) select col1, col2, ...
colN from TABLE1 where ...(primary key traversal condition).
which TABLE1 is under use, and TABLE2 has new structure.
Before I really do the copy task, I created some triggers to
synchronize the insert & update.
When I finally complete the task, I find ALL blob column appear to
result in inconsistent status with the orignal table.
There are users which do query and update on TABLE1.
So what's going wrong?
Thank you
Cui Shijun
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
