zjutke的专栏

select * from td_query_info t where exists (select 1 from td_query_price p where p.fphm=t.fphm and p.status=1)

UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def'); REPLACE(str,from_str,to_str) 在字符串 str 中所有出现的字符串 from_str 均被 to_str替换，然后返回这个字符串

select goods_id ,concat (",",GROUP_CONCAT(optiona_id),",") from `lux_product_goods_property_val` group by goods_id

公司下有多少未删除，已审核的的公司网点UPDATE energy_company t, (SELECT company_id, COUNT(1) total FROM energy_company_site WHERE delete_flag = 0 AND audit_flag=1 GROUP BY company_id) u SET

对于比较简单的表，数据量不是特别多的表，可以使用简单的sql语句来进行备份create table T_FA_Cat_20121207 as select * from T_FA_Cat创建一个新表，把数据保存起来insert into  T_FA_Cat  select * from T_FA_Cat_20121207把原来备份的数据导入到表中恢复数据

/** * 防止SQL注入 * @param str 传入字符串 * @return 处理后的字符串 */ public static String processSQLInjection(String str) { if (str != null && !"".equals(str)) { str = str

create or replace view v_td_allgg asselect id,boutname,startdate,enddate,type,hydm from (      select zb.ggid as id, zb.promc  as boutname, zb.gmbsjs as startdate,zb.gmbsks  as enddate,1 as type,n

CREATE INDEX index_name ON table_name (column_list)CREATE UNIQUE INDEX index_name ON table_name (column_list)DROP INDEX index_name ON talbe_name

SELECT title FROM wenda_category ORDER BY CONVERT(title USING gbk)