MySQL之常用SQL语句-白红宇

MySQL之常用SQL语句

阅读量：5064 次

发布时间：2019-06-12

本文共 1075 字，大约阅读时间需要 3 分钟。

　　1) 分表之后统计数据的总量

SELECT        (a0.total + a1.total + a2.total + a3.total + a4.total + a5.total + a6.total + a7.total) total    FROM    (        (            SELECT                count(*) AS total            FROM                wx_00        ) a0,        (            SELECT                count(*) AS total            FROM                wx_01        ) a1,        (            SELECT                count(*) AS total            FROM                wx_02        ) a2,        (            SELECT                count(*) AS total            FROM                wx_03        ) a3,        (            SELECT                count(*) AS total            FROM                wx_04        ) a4,        (            SELECT                count(*) AS total            FROM                wx_05        ) a5,        (            SELECT                count(*) AS total            FROM                wx_06        ) a6,        (            SELECT                count(*) AS total            FROM                wx_07        ) a7    );

转载于:https://www.cnblogs.com/xingxia/p/mysql_sql.html

你可能感兴趣的文章

ES6内置方法find 和 filter的区别在哪

查看>>

Android实现 ScrollView + ListView无滚动条滚动

查看>>

java学习笔记之String类

查看>>

UVA 11082 Matrix Decompressing 矩阵解压（最大流，经典）

查看>>

jdk从1.8降到jdk1.7失败

查看>>