473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Insertion of image -mysql

How to insert image in mysql?
Oct 3 '07 #1
2 1209
code green
1,726 Expert 1GB
Use the BLOB field.
But I recommend placing the address of the image in the DB only, and filing the images in a directory local to the DB
Oct 3 '07 #2
Atli
5,058 Expert 4TB
Hi. Welcome to The Scripts!

I agree with code green.

You can use BLOB to store binary data, which would be perfect for storing an image.

But it is much easier to store the image the old fashion way, on the file-system, and put it's location in the database as a string. This is the most sensible way for most cases.
Oct 3 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

20
by: Patrick Guio | last post by:
Dear all, I have some problem with insertion operator together with namespace. I have a header file foo.h containing declaration of classes, typedefs and insertion operators for the typedefs in...
5
by: John N. | last post by:
Hi All, Here I have a linked list each containing a char and is double linked. Then I have a pointer to an item in that list which is the current insertion point. In this funtion, the user...
0
by: Amar Ingole | last post by:
I am developing a small RTF writer using C# to generate Project Report by referring Microsoft's specifications to generate RTF code. Case 1: The method that I am using is, first get the page...
4
by: Andrix | last post by:
Hi, I have a table with 20.000.000 of tuples. I have been monitoring the performance of the insertion and updates, but not convince me at all. The table have 30 columns, what and 12 of it, are...
0
by: polocar | last post by:
Hi, I have noticed a strange behaviour of CurrencyManager objects in C# (I use Visual Studio 2005 Professional Edition). Suppose that you have a SQL Server database with 2 tables called "Cities"...
6
by: barcaroller | last post by:
If I insert/remove an element in a set, will an iterator to this set automatically become invalid? Does the position of the iterator before the insertion/removal matter? How are vectors and...
5
by: shaiful | last post by:
Hi All, I tried a lot also followed many previous example, still i cant get proper idea that how to insert an image file into database? I using VB and Access. for example: My File image file is...
1
by: newkhan | last post by:
Hi, If we want to insert the image in sql server table then how to do this and what should be the data type of the cell where image should be inserted. Similarly if we want to show this image...
2
mafaisal
by: mafaisal | last post by:
Hello Experts I am Using VB.Net 2005 And Sql 2005 I Want to Insertion of Image in to DataBase And its Retrievel And Also Passing of Images to Crystal Reports I am searching For This B coz I...
9
by: python_newbie | last post by:
I don't know this list is the right place for newbie questions. I try to implement insertion sort in pyhton. At first code there is no problem. But the second one ( i code it in the same pattern i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.