languageexpand_more
English Deutsch Español Français Русский язык Italiano 한어 简体中文 繁體中文 日本語

mysql 查看某数据库中所有表的行数

模糊计数

select table_name,table_rows from information_schema.tables 
where TABLE_SCHEMA = '<datebase_name>' 
order by table_rows desc;

精确计数

1.执行以下语句

select concat(
'select "',
table_name,
'", count(*) from ',
TABLE_SCHEMA,
'.',
table_name,
' union all'
) from information_schema.tables
where TABLE_SCHEMA='<datebase_name>';

2.复制第1步语句的查询结果,粘贴之后将最后一个union all替换为;

select "<table1_name>", count(*) from <datebase_name>.<table1_name> union all
select "<table2_name>", count(*) from <datebase_name>.<table2_name> union all
...
select "<tablen_name>", count(*) from <datebase_name>.<tablen_name>;

3. 复制第2步语句的查询结果,然后运行,查询结果如下:

+-------------+-------------+
| <table1_name>   | count(*)                 |
+-------------+-------------+
| <table1_name>   |      <table1_rows> |
| <table2_name>   |      <table2_rows> |
| ...                   | ...                      |
| <tablen_name>   |      <tablen_rows> |
+--------------------------+----------+

* 拓展:直接统计总数

select sum(sum1) from (
select count(*) as sum1 from <datebase_name>.<table1_name> union all
select count(*) as sum1 from <datebase_name>.<table2_name> union all
...
select count(*) as sum1 from <datebase_name>.<tablen_name>) as total;

查询结果如下:

+--------------------------+
| sum(sum1)        |
+--------------------------+
|<total_rows>|
+--------------------------+

Visual Studio Code Server 设置登录界面为中文

© Sunplace,2023
1. 修改<vscode-server-dir>/out/node/i18n/index.js

(0, i18next_1.init)({
    lng: "zh-cn",
    fallbackLng: "zh-cn",

2. 修改<vscode-server-dir>/out/node/routes/login.js

const locale = req.args["locale"] || "zh-cn";

3. 重启vscode(需事先安装配置supervisor

supervisorctl restart vscode

Visual Studio Code Server 进程守护

[MD]
© Sunplace,2023

1. 准备工作

1.1. 安装VS Code Server

网上千篇一律,不再赘述
参考链接:https://juejin.cn/post/6966772881552310303

1.2. 安装supervisor

参考《群辉NAS搭建Microsoft365订阅续期服务

2. 配置文件

在/etc/supervisord.conf末尾加上

[program:vscode]
command=/bin/sh code-server
directory=<vscode-server-dir>/bin
environment=ASPNETCORE_ENVIRONMENT=Production
stopsignal=INT
autostart=true
autorestart=true
startsecs=1
stderr_logfile=/var/log/vscode.err.log
stdout_logfile=/var/log/vscode.out.log

3. 重新加载supervisor

supervisorctl update
supervisorctl reload
supervisorctl start vscode

4. 启动VS Code Server

cd /usr/vscode/bin
./code-server