reids 操作备忘下 redis-cli -h 192.168.29.135 -p 6379 -a 18606927925 /usr/local/bin/redis-server /opt/redis-3.0.5/redis.conf
ngxin ./configure信息备忘 [size=x-large][color=red]./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-...
Mark20151225 SELECT review.*FROM `xx_review` review, `xx_order_item` item,xx_order_group gpLEFT JOIN xx_member_score score ON gp.order_form = score.`member_order`WHERE CHAR_LENGTH(review.`content`)...
Batch update returned unexpected row count from update [0]; actual row count Batch update returned unexpected row count from update [0]; actual row count[size=x-large][color=red]需要处理的数据已经发生变化,报这个错误。。。[/color][/size]
Batch update returned unexpected row count from update [0]; actual row count Batch update returned unexpected row count from update [0]; actual row count[size=x-large][color=red]需要处理的数据已经发生变化,报这个错误。。。[/color][/size]
oracle11G 导出,导入10G报错信息 [code="log"]Import started on 2015/4/25 9:47:43C:\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...
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(urlli...
查看oracle版本 [size=large]1 查看oracle的版本信息(1)用客户端连接到数据库,执行select * from v$instance 查看version项(2)select * from product_component_version(3)或查询V$VERSION查看组件级信息[/size]...
jquery设置按钮的disabled属性 [size=x-large]$('#button').attr('disabled',"true");添加disabled属性 $('#button').removeAttr("disabled"); 移除disabled属性[/size]
oracle主键自增 [code="SQL"]CREATE SEQUENCE TEST_TABLE_ID_Sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加,不循环 ...
java.lang.IllegalArgumentException: Illegal character in query at index 141: [code="log"]09-26 10:08:48.922: D/touchCheck(20124): ViewRoot's Touch Event : Touch Down09-26 10:08:48.992: V/AudioManager(20124): playSoundEffect effectType = 009-26 10:08:48.992: V/AudioManage...
查看表空间下用户表的大小(GB) 所占空间由大到小的前三十的数据表:[code="sql"]select * from (select segment_name,bytes/1024/1024/1024 as GB from dba_segments where owner = USER order by bytes desc ) where rownum ...
查看表空间(oracle)占用情况 [code="sql"]select total.tablespace_name,round(total.MB,2) as Total_MB,round(total.MB-free.MB, 2) as Used_MBfrom (select tablespace_name, sum(bytes)/1024/1024 as MB from dba_free_space group by ...
ORA-28000: the account is locked-的解决办法 进入sqlplusconn /as sysdba[code="sql"]alter user {username} account unlock;[/code]
oracle创建/增加 数据库表空间 创建表空间[code="sql"]create tablespace yyjklogging datafile 'E:\app\Administrator\oradata\orcl\yyjk_data.dbf' size 5000m autoextend on next 100m maxsize 20480m extent management local;...
自定义getElementsByClassName( ) 方法 [code="javascript"]function getElementsByClassName (className) { var all = document.all ? document.all : document.getElementsByTagName( ' *' ); var elements = new Array(); for ( var...
js object 转化为 json字符串 1.用object.constructor判断object类型[code="js"]function Serialize(obj) { switch (obj.constructor) { case Object: var str = "{"; for ( var o in obj) { str += o + ":" + Seriali...