Member Avatar for antonius61

Hi, wonder if anyone can help.
I want to insert a jpeg as blob data into a table column holding blob values. So far I just can't seem to come up with the right script to run in mysql workbench. The jpeg is stored on the same machine where mysql is running.
I have a similar table setup in SQL Server2005 and have managed to do the above with the following script:

INSERT INTO BLOBTable (BLOBName, BLOBData)
	SELECT 'door', BulkColumn FROM OPENROWSET(
			Bulk 'C:\Users\Laurentius\Documents\pegs\door.jpg' SINGLE_BLOB) AS BLOB

Anyone know how to do this in mysql?

Thanks for any help, Tony.

Edited by peter_budo because: Correcting code tags, closing tag is [/code]
  • 2 Contributors
  • 1 Reply
  • 138 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by AndreRet
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.