This question already has an answer here:
I want to move blob from one MySQL table to another table.
I try this:
mysql_query("INSERT INTO test1 Blob SELECT Blob FROM test");
But don't working and try with SELECT, then INSERT, but don't working.
Next question: If I want not Insert to another table, but update in another table what then do?
</div>
Syntax should be:
INSERT INTO test1 (`Blob`) SELECT `Blob` FROM test
What you've done here is to alias test1 as Blob. As always refer to the documentation on SELECT before randomly trying things. As a note, having Blob as a column name can be problematic as it's a reserved keyword.