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