mysql db insert error when using blob value

Question

using python adbapi the insert a row in a table in mysql

like insert ,id is a int, value is a blob

db.runQuery("INSERT INTO t (id, blob_value) VALUES (%(id)s, %(blob_value)s)", \
{
    "id" : id,
    "blob_value" : blob_value
}

Traceback: <class '_mysql_exceptions.ProgrammingError'>: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near INSERT INTO t (id, blob_value) VALUES (%(id)s, %(blob_value)s)",

and I think it could be a quote character - ' in the blob_value, is these the matter why it failed?

OK, the reason is the table name - "unlock" which is a key word of mysql.

Would any one help how to do delete a table named "unlock"?

What happens when you run the same code with a blob_value not containing any quotes? — Wooble
– Wooble, Commented May 7, 2012 at 10:14
thanks, i test it with an string without quote, the error still exists. — holsety
– holsety, Commented May 7, 2012 at 10:32
Do you have the necessary quotation marks around the blob? Is the blob really text only? Otherwise you will have to deal with it in a different kind i think — Argeman
– Argeman, Commented May 7, 2012 at 12:15
I know the problem, i named the table "unlock" which is a key word of mysql. so a create a table named "unlock" i can't use it anymore. the question is how to delete the table "unlock" after all. — holsety
– holsety, Commented May 7, 2012 at 12:22

Namphibian · Accepted Answer · 2012-05-07 12:26:47Z

1

Short answers:

DROP TABLE `UNLOCK`
SELECT * FROM `UNLOCK`

Use the mighty `

answered May 7, 2012 at 12:26

Namphibian

12.3k8 gold badges50 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

octern · Accepted Answer · 2012-05-07 12:27:55Z

1

Just put backticks around the table name:

drop table `unlock`;

answered May 7, 2012 at 12:27

octern

4,89623 silver badges40 bronze badges

Collectives™ on Stack Overflow

mysql db insert error when using blob value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related