如何将blob从一个表移动到另一个表？ [重复]

Question

This question already has an answer here:

• Syntax error due to using a reserved word as a table or column name in MySQL 1 answer

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>

Answer 1

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.