Insert Images to MySQL via SQL Statement?
MySQL
2
Posts
2
Posters
3
Views
1
Watching
-
-
Hi all, I am trying to insert a Blob data type into one of my tables. However, i can't seem to be able to find any information on how to do it via a Insert statement by using the MySQL query browser. If anyone knows, please help me out. Thanks!
From query browser: - make a select * from your table - Press the "Edit" Button on the bottom of the view - The BLOB field of the last row will show a little "open" icon. - Select the file and fill the other fields - Press "Apply Changes" (which is next to the "Edit" button") That's it? From .NET code: - Use a prepared statement.