如何使用mysql将视频存储在数据库中? [英] how to store video in database using mysql?

问题描述

我尝试使用MySQL将视频文件存储到数据库中，但是我不知道如何存储 视频文件存入数据库.我尝试以下查询，但是没有用.

I try to store a video file into database using MySQL, But i don't known how do store video file into database. I try following query but it didn't work.

     CREATE TABLE GAME  (
               GAME_ID INTEGER NOT NULL PRIMARY KEY,
               GAME_NAME VARCHAR (20),
               VIDEO  LONGBLOB );


INSERT INTO GAME  VALUES(3, "Termonator2", 
LOAD_FILE("C:\Users\Public\Videos\Sample Videos"));

请给我任何参考或提示.
任何帮助表示赞赏.

Please give me any reference or hint.
Any help is appreciated.

推荐答案

您需要在路径中添加两个斜杠.
检查以下查询.它与我一起工作.
用这个

you need to add two slash in path.
Check following query.it's work with me.
use this

INSERT INTO GAME values (3, 'Termonator2',LOAD_FILE("C:\\Users\\Public\\Videos\\Sample Video\\test.mpg"));   

代替

INSERT INTO GAME  VALUES(3, "Termonator2", 
LOAD_FILE("C:\Users\Public\Videos\Sample Videos"));  

享受.....

这篇关于如何使用mysql将视频存储在数据库中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！