DB是超级容易的:一个绘画表(id-name),一个绘画表(id-name)和一个连接颜色和绘画的表(painting_id - colour_id)。我使用这个查询(假设我有颜色4,5,6,7,8,9,10,11,12,13,14):( SELECT painting_id, count(color_id) AS matched FROM painting_colors WHERE color_id
(gdb) run Aa0Aa1Aa2Aa3Aa4Aa5Aa6Aa7Aa8Aa9Ab0Ab1Ab2Ab3Ab4Ab5Ab6Ab7Ab8Ab9Ac0Ac1Ac2Ac3Ac4Ac5Ac6Ac7Ac8Ac9Ad0Ad1Ad2Ad3Ad4Ad5Ad6Ad7Ad8Ad9Ae0Ae1Ae2Ae3Ae4Ae5Ae6Ae7Ae8Ae9Af0Af1Af2Af3Af4Af5Af6Af7Af8Af9Ag0Ag1Ag2Ag3Ag4Ag5Ag6Ag7Ag8Ag9Ah0Ah1Ah2Ah3Ah4Ah