工作積累

删除軟體表中多餘的重複記錄，重複記錄是根據單個字段（s_downloadurl）來判斷，隻留有sid最小的記錄

create table `temp` select s_downloadurl,min(sid) as sid from `software` group by 's_downloadurl' having count('s_downloadurl') > 1;

delete from `software` where 's_downloadurl' in (select 's_downloadurl' from `temp`) and 'sid' not in(select 'sid' from `temp`);

select s_downloadurl from `nsoftware` group by s_downloadurl having count(s_downloadurl)>1

ALTER TABLE `keyword` ADD UNIQUE (`k_id`)

$a='/<td width="310" rowspan="2">([\s\S]*)<a href="([^>]*)">/iU';//正則比對回車

preg_match($a,$page1,$view4);

print_r($view4);

exit;

www.yardvps.com 買空間的網站

www.vpszz.net

delete FROM `nkeyword` WHERE `nkeyword`='' and `id`<188034

SELECT * FROM `nkeyword` WHERE `nkeyword`='opera mini kb' and `nkeyword`!=''

select s_name,count(*) as con FROM `nsoftware` group by s_name order by con DESC

SELECT `sid` , count( * ) FROM `nsoftware` GROUP BY `s_sname` HAVING count( `s_sname` ) =1