(select * from CPPRADAR where RADARDESC= ‘新闻’ and status=0) b  

可以效仿linux下chmod的用法,直接用数字代表权限 

on a.parentid = b.parentid  

 

 

update 20121101_t set c2 = ‘f’ where id =1  

mysql批量插入规律数据

insert into 20121101_t  

 

2 b.txt x,r f 

(select * from CPPRADAR where RADARDESC=’互动’ ) a inner join   

select * from 20121101_t where FIND_IN_SET(‘r’,cl)>0  

Sql代码 www.2cto.com insert
into CPPRADAR( SITEID, RADARNAME, RADARDESC, PARENTID, RADARTYPE,
RADARQUERY, RADARCONFIG, CRUSER, CRTIME, OPERUSER, OPE…

Sql代码  

insert into CPPRADAR( SITEID, RADARNAME, RADARDESC, PARENTID,     

举例说把b.txt产生只读 

select 001, replace(a.RADARNAME,’互动’,’博客’) radarname, ‘博客’,
 a.RADARID  ,3, substr(b.RADARQUERY,6,6) , ‘条件’, ‘admin’, CURDATE(),
‘admin’, CURDATE(), 1  from  

 

Sql代码    www.2cto.com  

那时再看 

 

昨今不相同的是set能够取两个值,enum只好取一个 

 

  `id` int(11) NOT NULL AUTO_INCREMENT,  

 RADARTYPE, RADARQUERY, RADARCONFIG, CRUSER, CRTIME, OPERUSER, OPERTIME,
LEAF) 

Sql代码  

enum就相对轻松了,举例把a.txt从文件夹产生文件 

 

举例给b.txt文件加上实行权限 

select * from 20121101_t where cl&4  

1是因为x权限出现在了第四个 

1 a.txt w,r d 

  `c2` enum(‘f’,’d’) NOT NULL,  

  

  www.2cto.com  

Sql代码  

 

update 20121101_t set cl = cl&~2 where id =2  

永利皇宫登录网址 , 

再比如给b.txt文件去掉写权限 

网站地图xml地图