Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File link location in table field?

Status
Not open for further replies.
james0816

james0816

Programmer
Jan 9, 2003
295
US
how do you establish a file location in a mysql db? Say I have an picture located at c:\pictures\pic1.jpg.

I think the format is something like '\\pictures\\pic1.jpg' but i'm missing something.

can someone assist?

thx
 
Sort by date Sort by votes
Is there a reason you don't just use a varchar field and enter the actual file location in the field?

Code: 
INSERT INTO table_name (file_location_field_name) VALUES('c:\pictures\pic1.jpg');

***************************************
J. Jacobs
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
481
spamjim
spamjim
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
464
lupidol
lupidol
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
535
EdLentz
EdLentz
bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
374
bharons
bharons
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
211
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top