Insert Query 4 blob column

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
desmondlk
Forum Commoner
Posts: 27
Joined: Tue Sep 24, 2002 10:27 pm
Location: Malaysia

Insert Query 4 blob column

Post by desmondlk »

Dear all,

how can i insert a graphic into a blob column by using SQL statement?

the graphic is located in c:\
name as mb.gif


thanx in advance.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

What database are you running? Generally it's better just to save the path to the image in the database and then to use that in the HTML IMG tag in order to display the image again.

This topic has also been covered a few times before here so try a search on something like 'blob AND image'.

Mac
Post Reply