Re: Insert blob data using prepared statements

On 7/26/2010 2:30 AM, Manasi Save wrote: Hi All, I need to insert Blob data in my table using prepared statements. But Whenever I try to insert it using prepared statement it is giving me mysql syntax error. Here's the prepared statement :- SET @stmt = Concat(Insert into ',mydb,'.MyTable(

Insert blob data using prepared statements

Hi All,   I need to insert Blob data in my table using prepared statements. But Whenever I try to insert it using prepared statement it is giving me mysql syntax error.   Here's the prepared statement :-   SET @stmt = Concat(Insert into ',mydb,'.MyTable(MyData, MyID)      Select ','"',Inputdata,'"