· 7 years ago · Feb 26, 2019, 12:32 PM
1CREATE TABLE IF NOT EXISTS `docs` (
2 `id` int(6) NOT NULL AUTO_INCREMENT,
3 `car_id` int(6) unsigned NOT NULL,
4 `user_id` int(6) unsigned NOT NULL,
5 `status` VARCHAR(16),
6 PRIMARY KEY (`id`),
7 UNIQUE KEY (`car_id`,`user_id`)
8) DEFAULT CHARSET=utf8;
9
10INSERT INTO `docs` (car_id, user_id)
11VALUES (1, 2), (1, 3), (2, 2), (1, 3)
12 ON DUPLICATE KEY UPDATE `status`='sraka';