nidayu的blog

alter table userInfo add(msn varchar2(20)); 1、建表 create table userInfo ( id number(6), name varchar2(20), sex number(1), age number(3), birthda

创建存储过程--使用存储过程批量添加数据--排班管理create or replace type type_emp_work_plan as object(code nvarchar2(13),strut_type nvarchar2(30),strut_type_value nvarchar2(30),create_time date,operator nvarchar2(20

--列出各个部门中工资高于本部门的平均工资的员工数和部门号，并按部门号排序select * from emp e1,(select round(avg(sal),2) sal,deptno from emp group by deptno) e2 where e1.sal>e2.sal and e1.deptno=e2.deptno order by e1.deptno asc;

1，mysql将查询结果导入某个文件：select * from t_user into outfile 'E://1.txt';2，mysql的count(*)与count(id)之间的比较：1.任何情况下SELECT COUNT(*) FROM tablename是最优选择；2.尽量减少SELECT COUNT(*) FROM tablename WHERE

先导入mongo的jar包.MongoDB.javapackage com.util;import java.net.UnknownHostException;import java.util.ArrayList;import java.util.List;import org.bson.types.ObjectId;import com.mongodb.BasicDBOb

Util类:package com.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.naming.Con

导入jar包：2，RedisClient.java文件

1，mysql随机查询select * from 表名 order by rand() limit 10;2，sql server随机查询select top 10 * from 表名 order by newid();3，oracle随机查询select * from(select * from 表名 order by dbms_random.value)where ro