MYSQL创建数据表、存储图片等
1、创建数据库
CREATE DATABASE test;
use test;
2、创建student数据表
CREATE TABLE student
-> (
-> id INT(11),
-> name VARCHAR(25),
-> math INT(3),
-> chinese INT(3)
-> );
3、存储图片视频等
create table test (id interger not null primary key, name varchar(20), movie longblob);
insert into test values(1, "titabnic", load file("xxx/xxx.mp4"));