shizhijie737的专栏

DDL查看所有数据库创建数据库使用一个数据库删除数据库show databases;create database db;use db;drop database [if exists] db;查看所有表创建表查看表字段插入一条记录查看表记录show tables;create table tb(id int,

获取分组后的某条记录http://www.jb51.net/article/31590.htm

--查询约束select * from user_cons_columns--删除约束alter table table_test drop constraint SYS_C0039695;--添加主键alter table table_test add primary key (ID,FUND_CODE)--添加唯一约束alter table table_test

http://www.poluoluo.com/jzxy/201004/81961.html--select * from dba_users; 查询数据库中的所有用户　　--alter user TEST_SELECT account lock; 锁住用户　　--alter user TEST_SELECT account unlock; 给用户解锁　　--c

select b.[value] from sys.columns a left join sys.extended_properties b on a.object_id=b.major_id and a.column_id=b.minor_id inner join sysobjects c on a.column_id=c.id and a.[name]='列名' and c

Sql Server 数据分页http://www.cnblogs.com/qqlin/archive/2012/11/01/2745161.html

navicat.exe（mysql）

http://www.cnblogs.com/xiepeixing/archive/2012/04/18/2583955.html

create table TABLE2 as select * from table1 t where id='A' insert into table2 select * from table1 where id='B'

http://dongisland.iteye.com/blog/11727021、PL/SQL Developer记住登陆密码   在使用PL/SQL Developer时，为了工作方便希望PL/SQL Developer记住登录Oracle的用户名和密码；   设 置方法：PL/SQL Developer 7.1.2  ->tools->Preferences->Oracle-

select t.s_info_windcode,    REPLACE(t.s_info_windcode,'.','') as pilot_product_id ,    'BOND' as instrument_class ,     (select s_info_industrycode from CBondIndustryWind where s_info_windcode=