How to store video files directly in the MySQL database

To test how to store video files in mysql DATA, we do not recommend that you store them directly, because migration is troublesome and prone to problems. The following is only a test function, importing jpg, png, and other images is similar.

Create a test table using longblob or mediumblob

Create table test (id integer not null primary key, name VARCHAR (20), movie LONGBLOB );

Import the video file

Insert into test VALUES (1, 'titanic ', LOAD_FILE ("/tmp/good.mp4 "));

Note: The following error may occur if you do not use longblob: