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,'"',',',InputID,';');
 
Prepare stmt1 From @stmt;
Execute stmt1;
Deallocate prepare stmt1;
 
The executing statement looks like this :-
 
Insert into `mydb`.MyTable(MyData, MyID)
Select ** STREAM DATA **, 1;
 
This gives me an error saying mysql syntax near ** STREAM DATA..................
 
 
Can anyone give me any example how to insert blob data in database with prepared statement.
 
Thanks in advance.

--
Regards,
Manasi Save
Artificial Machines Private Limited
manasi.s...@artificialmachines.com
Ph:-9833537392

Reply via email to