Kemin Zhou wrote:
Hi All,
I have one of the toughest problem to solve now. I have not been able
to sleep well in the last three days.
There is a simple query
insert into table foo (column1, column2, column5)
select $col
from bar
If I run this query by hand whatever the value of $col, it works fine.
The insertion was done.
If I run this query with other values of $col this sql works fine if
$col is not name.
If $col eq "name" then the insertion does not happen and no error
message is given.
(Of course, if I run the same query by hand, then this works fine).
I would first get some sleep, then enable DBI tracing and turn on the
MySQL general query log and see what query is really getting sent to the
server.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]