当排序文件的数据重复时,MySql如何排序数据?sort2,a,b from orderby_test where sort1 = 1 and a = 1 and b = 1 order by sort2 desc limit 0, 1000id sort1 sort2 a b2 1 3 1 1id是ASC
然后插入数据mysql
将数据插入到MYSQL数据库工作正常。但是在插入数据之前,我需要检查重复项。这是我在MYSQL的Product Table中检查名称重复的代码。int nQueryState = 0;
nQueryState = mysql_query(&conn, "SELECT * FROM product WHERE EXISTS, "My first Gui", MB_OK);