· 7 years ago · Mar 01, 2019, 10:52 AM
1CREATE TABLE IF NOT EXISTS images
2(
3 id int not null auto_increment primary key,
4 image longblob not null
5);
6
7CREATE TABLE IF NOT EXISTS jobs
8(
9 id int not null auto_increment primary key,
10 name varchar(255) not null,
11 description text,
12 salary int,
13 site int not null,
14 foreign key (site) references images (id)
15);
16
17INSERT INTO images VALUES (1, LOAD_FILE('/home/user/hh.png'));