Do not escape the single ticks.
-----Original Message-----
From: Jorge Infante Osorio. [mailto:jorg...@facinf.uho.edu.cu]
Sent: Wednesday, December 03, 2003 8:32 AM
To: mys...@lists.mysql.com
Subject: Problem whit DELETE
Hi, I new in this list and I have a problemand I hope that
any of you can resolve or help me,
When I try to delete anything of a table from my
database, appear this error:
ERROR: Unclosed quote @ 46
STR: '
SQL: DELETE FROM `usuarios` WHERE `Login` = \'Root\' AND `Password`
= \'0f9190443d710f90275f66bb723ed6fd\' AND `Acceso` = \'1\' LIMIT 1
SQL-query :
DELETE FROM `usuarios` WHERE `Login` = \'Root\' AND `Password` =
\'0f9190443d710f90275f66bb723ed6fd\' AND `Acceso` = \'1\' LIMIT 1
MySQL said:
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 '\'Root\' AND
`Password` = \'0f9190443d710f90275f66bb723ed6fd
And I don't know what can I do to resolved that......
Any sugestion?????
Jorge.
2 messages in com.mysql.lists.mysqlRE: Problem whit DELETE
