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#.