夏微凉秋微暖的博客

C.1系统命令1)启动MySQL。mysqladmin start/ect/init.d/mysql start2）重启MySQL。mysqladmin restart/ect/init.d/mysql restart3)关闭MySQL。mysqladmin shutdown/ect/init.d/mysql shutdown4)连接本机上的MySQL。进入目录mysgl\bin，键人命令mysql-uroot -p，回车后提示输入密码。使exit 退出 MySQL。5)修改MyS

INSERT IGNORE INTO t_question_basket ( user_id, stage, SUBJECT, question_id, structure_type, question_source, is_del )VALUES ( '1', 'a', 'e', '2', 'danxuan', 0, 0 ) ON DUPLICATE KEY UPDATE stage=values(stage), SUBJECT=values(SUBJECT),.

tns：113 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.113)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )ORCL = (DESCR...

在plsql中，打开Objects窗口---》my objects找Sequences文件夹》你需要修改的Sequence选中你需要修改的sequence，右键edit(编辑)转载地址：https://www.cnblogs.com/svennee/p/4083345.html...

1.查看定时任务crontab -l提示：no crontab for rootcrontab -e后:wq2.写脚本#!/bin/bashsource /home/oracle/.bash_profileDATE=$(date +%Y%m%d)expdp QH_MIS_BASE/111 directory=DATA_PUMP_DIR dumpfile=QH_M...

1.添加：@Transactional2.抛出runtime异常throw new RuntimeException("参数错误,事物回滚"); @Override @Transactional public Message updateSeed(JSONObject jsonObject) { Message message = new...

在开发项目当中，程序报错信息如下：java.lang.RuntimeException: java.sql.SQLException: ORA-04031: 无法分配 4064 字节的共享内存 ("shared pool","INSERT INTO t_pm(PM_CODE, NA...","sga heap(1,0)","kglsim heap") Query: INSERT INTO ...

1.查看所有的序列：select * from user_sequences;2.plsql添加序列

SELECT ( CASE WHEN (SUBSTR(xxjgdzdm, 10, 1) = '0') OR (SUBSTR(xxjgdzdm, 10, 1) = '1') OR (SUBSTR(xxjgdzdm, 10, 1) = '4') THEN '0' WHEN (SUBSTR(xxjgdzdm, 10, 1) = '2') OR (SUBSTR(xxjgd...

#用oracle用户登录su oracle#设置环境变量source /home/oracle/.bash_profile#进入pssql启动数据库sqlplus / as sysdbastartup#退出pssqlexit#启动监听(oracle用户）lsnrctl start#停防火墙(root 用户)/etc/init.d/iptables status/...

1.分页的时候为了加一个恶心的筛选，写了一个超级复杂的sql：总结：--因为要筛选id在某一个集合，但是集合数据又是需要两个连表查询sum值，因为一起连表会造成数据紊乱，所以--1.通过left join 的方式通过id匹配成 id - num1 -num2 -num3的样式--2.两个数据通过union的方式连接，比 and (in  or  in)的方式效率要高--3.in在使用过程中  wh...

多表查询SELECT * FROM t_postulant_files t LEFT JOIN t_file t1 ON t.file_id = t1.id WHERE t.postulant_id =10; select t1.id, t1.name, t1.fileurl, t1.filetype, t1.size, t1.bucket, t1.access_typ

时间的查询：oracle：select * from 表名 where to_char(DATE_TRAVEL,'yyyy-mm-dd')='2014-01-01'

查询数据库的所有表select * from user_tables 查询数据库的某个表名为XXXselect * from user_tables  where tablespace_name = 'TIM_MIS_BASE'查询所有表名：select t.table_name from user_tables t;查询所有字段名：select t.column_na

运行以下代码：-- Create sequence create sequence ACCOUNT_SEQminvalue 1maxvalue 999999999999999999999999999start with 1increment by 1cache 20;

CREATE OR REPLACE FUNCTION IS_DATE(mydate in varchar2) RETURN NUMBER IS tmp DATE;BEGIN tmp := TO_DATE(nvl(mydate,'00'), 'yyyy-MM-dd'); RETURN 1; EXCEPTION WHEN OTHERS THEN...

CREATE OR REPLACE PROCEDURE "DELETE_SAME_JSZGXX_TMP" ASv_jsid VARCHAR2(50);v_num VARCHAR2(50);v_idd VARCHAR2(50);Cursor cursor1 is SELECT jsid,count(1) as num from TB_BIZ_JSZGXX_tmp GROUP BY js...

1.查询被锁定的select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session se...

1.导出source /home/oracle/.bash_profile //先设置下参数expdp SX_SZD_MIS_BASE/xxxxx directory=DATA_PUMP_DIR dumpfile=SX_SZD_MIS_BASE_2018_04_23.DMP schemas=SX_SZD_MIS_BASE//导出数据库expdp QH_MIS_BASE/xxx...

添加字段：ALTER TABLE [t_team] ADD change int DEFAULT 0ALTER TABLE [t_team_price] ADD change int DEFAULT 0删除字段： alter table [表名] drop 字段名修改字段：一、修改字段默认值alter table 表名 drop constr