|
UPDATE ltkjpeisTest.tj_project a
|
JOIN ltkjpeisTest.tj_project_beifen b ON b.pro_id = a.pro_id
|
SET a.pro_default = b.pro_default,a.pro_scope = b.pro_scope,a.result_type = b.result_type;
|
|
|
|
# 查看数据库占用内存大小
|
SELECT table_schema AS 'Database',
|
SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)'
|
FROM information_schema.tables
|
WHERE table_schema = 'ltkjpeis10'
|
GROUP BY table_schema;
|
|
# 查看设置中预设的数据库内存大小
|
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
|
|
# 查看最大的连接数
|
SHOW VARIABLES LIKE 'max_connections';
|
|
CREATE TABLE tj_report_special_project (
|
id BIGINT PRIMARY KEY NOT NULL,
|
pro_id BIGINT NOT NULL UNIQUE,
|
template_key TINYINT(2) NOT NULL COMMENT '模板判断编号 根据编号走不同的生成模板类型',
|
params TEXT NULL COMMENT '需要额外传递的参数'
|
) COMMENT '报告特殊项目';
|
|
|
-- 凌云数据
|
INSERT INTO tj_report_special_project VALUES(1623853479200546816,1862852701533012001,1,'{"dy":"4.0","xy":"4.0","title":"阳性参考值：","dystr":"DOB值： ≥ ${dy} HP-阳性","xystr":" < ${xy} 正常","en":"DOB"}');
|
|
|
-- 县医院数据
|
INSERT INTO tj_report_special_project VALUES(1623853479200546817,1870371396991955967,1,'{"dy":"100","xy":"100","title":"参考值(DPM)：","dystr":"DPM值： ≥ ${dy} 阳性","xystr":" < ${xy} 阴性","en":"DPM"}');
|
|
|
SELECT * FROM tj_report_special_project;
|
