garsaud · February 20, 2019 17:27
diff --git a/duplicates.sql b/duplicates.sql
 delete t1 from book t1
 inner join book t2 
 where t1.id > t2.id
 and t1.title = t2.title
 and t1.user_id = t2.user_id
 and t1.category_id = t2.category_id;
	delete t1 from book t1
	inner join book t2
	where t1.id > t2.id
	and t1.title = t2.title
	and t1.user_id = t2.user_id
	and t1.category_id = t2.category_id;