· 7 years ago · Jan 15, 2019, 11:10 PM
1insert into picture_table ('picture name','folder') values ('holiday_123.png',FLOOR(pic_id/1000)
2
3CREATE TABLE IF NOT EXISTS `picture_table` (
4 `pic_id` int(8) NOT NULL AUTO_INCREMENT,
5 `picture_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
6 `folder` varchar(8) NOT NULL,
7 (...other stuff...)
8 PRIMARY KEY (`pic_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1