
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';
