See Thread at: http://www.techienuggets.com/Detail?tx=78262 Posted on behalf of
a User
I have no problems in copying MEDIUMBLOB type data from one table to another.
Under either 5.0 or 5.1 community editions.
In Response To:
hi,
I found this: http://bugs.mysql.com/bug.php?id=34300 in
hi,
I found this: http://bugs.mysql.com/bug.php?id=34300 in the bug system.
As it descibed, there is chance which I get corrupted data when read BLOB.
Now I wonder why I also get corrupted data when write BLOB into table...
I tried this:
step 1: read BLOB data from TABLE1
step 2:
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