2017-11-18
177
0
WordPress的注册用户数据主要存储在wp_users和wp_usermeta两个表中。
wp_usermeta表中的user_id字段，连接到wp_users表的id字段（user_login为用户名）
删除sql如下：
delete from wp_users where user_login not in ('mutou','1449773100','wangbn88','youyouyun','wangjiansheng');
delete from wp_usermeta where user_id not in ('1033','1282','1309','1385','1673');…继续阅读 » 
2016-11-24
373
0
1093错误：MySQL不能指定更新的目标表在FROM子句
mysql> delete from t where id in (select id from t where id < 5); ERROR 1093 (HY000): You can't specify target table 't' for update in FROM clause mysql>
这样删除将报错，更改SQL语句为
mysql> delete from t where id in (select * from (select id from t where id < 5) tmp); Query OK, 4 rows affected (0.00 sec)
…继续阅读 » 
2016-11-14
379
0
oracle锁表解锁命令如下：
select distinct a from (SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS ,'alter system kill session ''' || l.SESSION_ID || ',' || s.SERIAL# || ''';' a
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID);
执行该命令后，再次执行结果语句，即可解锁！ 
2016-10-10
394
0
前提
如果您用的是wamp等集成环境，将phpmyadmin放入网站跟目录出现无法访问，没有权限的提示，解决方案：
修改phpmyadmin配置文件phpmyadmin.conf位于"c:/wamp/apps/phpmyadmin3.4.10.1/"目录
<Directory "c:/wamp/apps/phpmyadmin3.4.10.1/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Allow from all
修改密码的…继续阅读 » 
2016-9-26
387
0
经常忘了oracle中tnsnames.ora的路径吧？
oracle 9i 是：oracle/oracle92/network/admin/
oracle 10g 是：oraclexe/app/oracle/product/10.2.0/server/NETWORK/ADMIN
oracle 11g 是：oracle11g/product/11.1.0/db_1/NETWORK/ADMIN
tnsname.ora中各个字段的含义又是什么呢？详情见下图
