URL

• https://github.com/openimages/dataset

mysql -u root -p

create database openimage;

use openimage;

CREATE TABLE image_vals (
ImageID VARCHAR(32) NOT NULL,
OriginalURL TEXT NOT NULL,
OriginalLandingURL TEXT NOT NULL,
License VARCHAR(255) NOT NULL,
AuthorProfileURL TEXT NOT NULL,
Author VARCHAR(32) NOT NULL,
Title TEXT NOT NULL,
PRIMARY KEY (ImageID)
);

LOAD DATA LOCAL INFILE "/home/takasi/ダウンロード/images_2016_08/validation/images.csv" INTO TABLE images  FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

sudo bash -c 'printf "[client]\ndefault-character-set=utf8mb4\n[mysql]\ndefault-character-set=utf8mb4\n[mysqld]\ncharacter-set-server=utf8mb4\ncollation-server=utf8mb4_unicode_ci\n" >> /etc/mysql/my.cnf'

sudo service mysql restart

mysql -u root -p
create database openimage;
use openimage;
show variables like '%char%';