lihongtai的专栏

原创 sql经典语句

查询某张表中某些列一样的记录 selelect * from tableName group by column1,column2 having count(*) > 1; 表中某个字符串中部分字符用其他字符代替 update NEWRESOURCE set CODE = REPLACE (CODE ,'0040','004') where CODE like '0040%'...