1st search list for binary storage to read about pro/cons (been debated before)
If you still want to do it either use load_file, or a loader application... I don't reccomend using longblob to store big files.. Use the 64k blob and inode/chunk the data.. better for streaming it out if that's what your planning to do.. > example php code @ http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Tue, 22 Jul 2003, Steven Wu wrote: > Hi Need emergency help: > I am doing some project use the MySQL to store the video file. > The format of video is either avi or mpg. However I can not successfully insert the > video file into the cooresponding field of a table by using the "LOAD_FILE" > function. Does anyone know how to store video into MySQL database server ? Please > help me, > thank you in advance. The following is my table and SQL code. > > > > CREATE TABLE GAME ( > GAME_ID INTEGER NOT NULL PRIMARY KEY, > GAME_NAME VARCHAR (20), > VIDEO LONGBLOB > ); > > > INSERT INTO GAME GAME_ID, GAME_NAME, VIDEO VALUES(2, 'Termonator2', > LOAD_FILE("/tmp/tm.mpg"); > > > > > My email is [EMAIL PROTECTED] > > > > > > Steven Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
