hnhxgxz的专栏

顺便提下mysql的DISTINCT的关键字有很多你想不到的用处 1.在count 不重复的记录的时候能用到 比如SELECT COUNT( DISTINCT id ) FROM tablename; 就是计算talbebname表中id不同的记录有多少条 2,在需要返回记录不同的id的具体值的时候可以用 比如SELECT DISTINCT id FROM tablename; 返...

（1）mysql limit 不支持子查询像下面这条语句无法执行 [b]SELECT * FROM b_c_s1 where CT_ID IN (SELECT DISTINCT CT_ID FROM b_c_s1 LIMIT 0,2);[/b] （2）应该在只查询外面再加一个查询 [b]SELECT * FROM b_c_s1 where CT_ID IN ([color...

update stockout_order,(SELECT stockout_order.stockoutOrderId, GROUP_CONCAT(sku.systemCode ORDER BY stockout_order.stockoutOrderId,sku.systemCode asc) systemCodes from stockout_order INNER JOIN sto...

declare v_no varchar(200); declare v_begin varchar(200); set v_no='111'; 提示 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set' 修...