摘要: 查询ORACLE字符集 --select userenv('language') from dual; --select * from v$nls_parameters; --select * from nls_database_parameters; --select * from sys.props$; mysql:show variables like '%char%'; SQLSE... 阅读全文
posted @ 2017-02-17 15:53 AlgorithmInit 阅读(302) 评论(0) 推荐(0) 编辑
摘要: oracle select * from ( select rownum as rn,HDMS.HD_PURGE_STATUS.* from HDMS.HD_PURGE_STATUS where rownum 10 and rn2) YY; MySQL select * from sakila.actor limit 10,10; 数据量大时,2个参数limit性能有影响,用如下:vid是表... 阅读全文
posted @ 2017-02-17 15:52 AlgorithmInit 阅读(687) 评论(0) 推荐(0) 编辑