upload reaction files into mysql

drop table reaction; CREATE TABLE `reaction` ( `reaction_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `emoji_name` varchar(45) DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `photo_link` varchar(255) DEFAULT NULL, `creator_user_id` int(10) unsigned NOT NULL DEFAULT '1', `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `tags` varchar(255) DEFAULT NULL, `type` int(1) DEFAULT NULL, PRIMARY KEY (`reaction_id`), UNIQUE KEY `reaction_id_UNIQUE` (`reaction_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; LOAD DATA LOCAL INFILE '/Users/noteyltd/Downloads/reactions.csv' into table reaction FIELDS TERMINATED BY ',' enclosed by '"' lines terminated by '\r\n' (emoji_name, tags) SET type = 1;

Comments