OUR SERVICES

MYSQL替换语句，MYSQL替换SQL代码
UPDATE IGNORE book_resource set book_resource_url=REPLACE(`book_resource_url`,'www.sanyewu.com','www.kanshuhezi.com');
这里意思是把book_resource表里book_resource_url字段的www.sanyewu.com替换为www.kanshuhezi.com，也可以替换为空，UPDATE IGNORE book_resource set book_resource_url=REPLACE(`book_resource_url`,'www.sanyewu.com','');这里的意思就是直接把数据库book_resource表book_resource_url字段内的www.sanyewu.com删掉
MYSQL查询重复数据语句，MYSQL查询重复数据SQL代码
select * from book_resource where book_resource_url in( select book_resource_url from book_resource group by book_resource_url having count(book_resource_url)>=2);
这里实例的语句，book_resource为表名、book_resource_url为字段名
MYSQL删除重复数据，只保留ID最小的那一条数据
delete from book_resource where book_resource_id not in (
    select t.min_id from (
        select min(book_resource_id) as min_id from book_resource group by book_resource_url
        ) as t
    );