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
- Insert blob data using prepared statements Manasi Save
- Re: Insert blob data using prepared statements Shawn Green (MySQL)