数据库相关

1.MYSQL导出长数字到Excel避免转为科学计数法方法

总结：

如果只需要导出展示、打印：可使用CONCAT("\t",str)

如果需要后续处理，引用，最好使用CONCAT("'",str)或者CONCAT("\'",str)，并导出为EXCEL文件。

2.mysql实现序列start

drop table if exists mmd_sequence;

create table mmd_sequence (

seq_name VARCHAR(50) NOT NULL, -- 序列名称

current_val INT NOT NULL, -- 当前值

increment_val INT NOT NULL DEFAULT 1, -- 步长(跨度)

PRIMARY KEY (seq_name)

);

create function currval(v_seq_name VARCHAR(50))

returns integer

begin

declare value integer;

set value = 0;

select current_val into value

from mmd_sequence

where seq_name = v_seq_name;

return value;

end;

create function nextval (v_seq_name VARCHAR(50))

returns integer

begin

update mmd_sequence

set current_val = current_val + increment_val

where seq_name = v_seq_name;

return currval(v_seq_name);

end;

3.数据库锁表常见处理方法：

select b.owner,b.object_name,a.session_id,a.locked_mode

from v$locked_object a,dba_objects b where b.object_id = a.object_id;

select b.username,b.sid,b.serial#,logon_time

from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time;

alter system kill session'1025,41';

其中1025为sid,41为serial#.