Loading Images into SQL SERVER using SQL

Any ideas?

 

Typically a filepath, not the actual image. Image is then loaded, and rendered by the application.

 

And this tells me...?

I need UPDATE table name set image = "whatever"...
The code buddy not talk...
I already know all that...
Thanks...

 

Here is a link to the UPDATE syntax in mysql:

http://dev.mysql.com/doc/refman/5.1/en/update.html

For instance, if you want to update an old image with a new one everywhere in your table, you would use something like this:

Code:

UPDATE tableName SET image = 'file path/new_image.jpg' WHERE image = 'file path/old_image.jpg';

The key is the where clause... you have to make sure it is specific enough to change only the lines you want changed. If you aren't sure, you can use the START TRANSACTION command that can be either committed or rolled back after you see the results of your command. You can find that syntax here:

http://dev.mysql.com/doc/refman/5.1/en/commit.html