Why not change VIDEO -> VIDEO_PATH and just use the directory path as a varchar() field to point you to the file stored on your computer. That way you don't have to worry about it. Whenever I need to use images or large files of some type, I just put it in a directory and reference the path to it. like this...
INSERT INTO GAME GAME_ID, GAME_NAME, VIDEO_PATH VALUES(2, 'Termonator2', '/tmp/tm.mpg'); That leaves you to handle opening it or viewing it in your own code when you query though. HTH Brian -----Original Message----- From: Steven Wu [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:04 PM To: [EMAIL PROTECTED] Subject: store video file into MySQL database server 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]
