要获得MySQL结果的最后一行的总数,请使用以下语法-(
SELECT yourColumnName1,
yourColumnName2,
yourColumnName3,
.
.
N
FROM yourTableName
)
UNION
(
SELECT "yourMessage" AS anyAliasName1,
SUM(yourColumnName1) AS anyAliasName2,
SUM(yourColumnName2) AS anyAliasName3,
.
.
N
FROM yourTableName
);
为了理解上述语法,让我们创建一个表。创建表的查询如下-mysql> create table ProductDemo
-> (
-> ProductId varchar(10),
-> ProductQuantity int,
-> ProductValue int
-> );
使用insert命令在表中插入一些记录。查询如下-mysql> insert into ProductDemo values('Product-1',10,300);
mysql> insert into ProductDemo values('Product-2',5,200);
mysql> insert into ProductDemo values('Product-3',7,340);
mysql> insert into ProductDemo