mysql 获得表名

Question

怎样得到一条记录的同时获得它所在表的表名，并在同一行显示出来MySQL表名

Answer 1

mysql> select *,'test1' from test1 limit 1;
+------+---------+-------+
| a    | id      | test1 |
+------+---------+-------+
|    0 | 3000000 | test1 |
+------+---------+-------+
1 row in set (0.00 sec)

Answer 2

concat(select '",@a,"',SaveNodeID,count(SaveNodeID),round(sum(FileSize),3) group by storageID from ",@a);
@a是存储表名的变量，这样写行吗？

Answer 3

set @asql=concat('select "',@a,'",SaveNodeID,count(SaveNodeID),round(sum(FileSize),3) group by storageID from ',@a);
prepare stml from @asql;
execute stml;

Answer 4

insert into sys_stadatasave(DATATYPEID,storageID,datanum,productTotalSize) 
select distinct 'AA0201_56b31e218d6bf04ca755a83d8c5d4fed',SaveNodeID,count(SaveNodeID),round(sum(FileSize),3) from AA0201_56b31e218d6bf04ca755a83d8c5d4fed group by SaveNodeID

Answer 5

@A的内容是AA0201_56b31e218d6bf04ca755a83d8c5d4fed？

Answer 6

select distinct 'AA0201_56b31e218d6bf04ca755a83d8c5d4fed',SaveNodeID,count(SaveNodeID),round(sum(FileSize),3) from AA0201_56b31e218d6bf04ca755a83d8c5d4fed group by SaveNodeID在MYSQL中运行，结果是什么