希望不是无解
i_am_birdman · 共 173 篇文章
reids 操作备忘下
redis-cli -h 192.168.29.135 -p 6379 -a 18606927925 /usr/local/bin/redis-server /opt/redis-3.0.5/redis.conf
2016-04-14 16:23 · 评论(0)
ngxin ./configure信息备忘
./configure --with-pcre='/usr/share/doc/pcre-7.8/' --with-zlib='/usr/share/doc/zlib-1.2.3/' --with-openssl='/usr/lib64/openssl/' --with-sha1='/usr/share/doc/perl-Digest-SHA1-2.12/' Configuration summary + using PCRE library: /usr/share/doc/pcre-7.8/ + using OpenSSL library: /usr/lib64/openssl/ + us…
2016-01-01 19:05 · 评论(0)
Mark20151225
SELECT review.* FROM xx_review review, xx_order_item item, xx_order_group gp LEFT JOIN xx_member_score score ON gp.order_form = score. member_order WHERE CHAR_LENGTH(review. content )>= 10 and gp.id=item.order_group AND review. order_items = item. id AND score. id IS NULL INSERT INTO xx_member_scor…
2015-12-25 15:30 · 数据库 · 评论(0)
Batch update returned unexpected row count from update [0]; actual row count
Batch update returned unexpected row count from update ; actual row count 需要处理的数据已经发生变化,报这个错误。。。
2015-11-12 10:27 · 数据库 · 评论(0)
javascrip 冒泡,冒泡阻止
http://www.cnblogs.com/webflash/archive/2009/08/23/1552462.html
2015-06-27 09:14 · Web前台 · 评论(0)
oracle11G 导出,导入10G报错信息
Import started on 2015/4/25 9:47:43 C:\oracle\product\10.2.0\db_1\bin\imp.exe log=C:\Users\ADMINI~1\AppData\Local\Temp\plsimp.log file=G:\cms\xmdscms.dmp userid=cms/123456@ORCL buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes 连接到: Oracle Database 10…
2015-04-25 13:30 · 评论(0)
subLime text 3 安装package Control
import urllib2,os; pf='Package Control.sublime-package'; ipp=sublime.installed_packages_path(); os.makedirs(ipp) if not os.path.exists(ipp) else None; urllib2.install_opener(urllib2.build_opener(urllib2.ProxyHandler())); open(os.path.join(ipp,pf),'wb').write(urllib2.urlopen('http://sublime.wbond.ne…
2015-04-19 14:11 · Web前端 · 评论(0)
查看oracle版本
1 查看oracle的版本信息 (1)用客户端连接到数据库,执行select * from v$instance 查看version项 (2)select * from product_component_version (3)或查询V$VERSION查看组件级信息
2015-01-15 11:18 · 数据库 · 评论(0)
jquery设置按钮的disabled属性
$('#button').attr('disabled',"true");添加disabled属性 $('#button').removeAttr("disabled"); 移除disabled属性
2014-12-18 18:28 · Web前端 · 评论(0)
oracle主键自增
CREATE SEQUENCE TEST_TABLE_ID_Sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加,不循环 NOCACHE --无缓冲区 INSERT INTO TEST_TABLE (ID,REMARK) values (TEST_TABLE_ID_Sequence.Nextval,'TEST_REMARK') ;
2014-11-26 16:37 · 数据库 · 评论(0)
java.lang.IllegalArgumentException: Illegal character in query at index 141:
09-26 10:08:48.922: D/touchCheck(20124): ViewRoot's Touch Event : Touch Down 09-26 10:08:48.992: V/AudioManager(20124): playSoundEffect effectType = 0 09-26 10:08:48.992: V/AudioManager(20124): playSoundEffect querySoundEffectsEnabled = false 09-26 10:08:48.992: D/FileTransfer(20124): download http…
2014-09-26 10:28 · 评论(0)
查看表空间下用户表的大小(GB)
所占空间由大到小的前三十的数据表: select * from ( select segment_name,bytes/1024/1024/1024 as GB from dba_segments where owner = USER order by bytes desc ) where rownum <= 30 查询表名为table_name的数据表大小 select round(BYTES/1024/1024/1024,2)||'GB' from user_segments where segment_name=table_name
2014-07-21 14:31 · 数据库 · 评论(0)
查看表空间(oracle)占用情况
select total.tablespace_name,round(total.MB,2) as Total_MB, round(total.MB-free.MB, 2) as Used_MB from (select tablespace_name, sum(bytes)/1024/1024 as MB from dba_free_space group by tablespace_name) free, (select tablespace_name, sum(bytes)/1024/1024 as MB from dba_data_files group by tablespace_…
2014-06-24 11:03 · 数据库 · 评论(0)
ORA-28000: the account is locked-的解决办法
进入sqlplus conn /as sysdba alter user {username} account unlock;
2014-05-19 21:58 · 数据库 · 评论(0)