Click here to Skip to main content
15,117,318 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
How to insert audio file in mysql.I want code.
Posted
Comments
TorstenH. 3-Aug-11 7:08am
   
you don't "want" code - you need to request it PLEASE!

1 solution

Yo can use LOAD_FILE, something like this:
SQL
UPDATE t
  SET blob_col=LOAD_FILE('/tmp/picture/audio.mp3')
  WHERE id=1;

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_load-file[^]

Good luck!
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900