select (SELECT COUNT(1) from a1) as a1 ,(SELECT COUNT(1) from a2) as a2,(SELECT COUNT(1) from a3) as a3,(SELECT COUNT(1) from a4) as a4
解决方案 »
- 急求解决mysql无法远程连接问题ERROR 2003 (HY000): Can't connect to MySQL server on '202.99.67
- Mysql集群安装包的问题,谢谢
- 问以下Deadlock 如何产生并如何解决
- 关于mysql的分区
- mysql备份数据库中的“灵异事件”,怪~~~~ 求高手解答。。。
- 菜鸟问题。。。。
- 求助mysql的存储过程的问题
- MYSQL FRONT 2.5不支持定义外键,还有没有更好的front??
- 一个查询语句的问题,在线等待
- mysql如何支持中文??在servlet里面读出,写入该怎么处理中文呢?
- 高手们。快来了。这种SQL怎么实际呢?
- mysql 中表与表之间关联问题及优化!在线等待。
select * from a1 limit 5 union all select * from a2 limit 10;
Query OK, 0 rows affected (0.00 sec)mysql> select @index1:=count(*) from send;
+-------------------+
| @index1:=count(*) |
+-------------------+
| 10 |
+-------------------+
1 row in set (0.02 sec)mysql> set @index2:=0;
Query OK, 0 rows affected (0.00 sec)mysql> select @index2:=count(*) from sendlog;
+-------------------+
| @index2:=count(*) |
+-------------------+
| 122259 |
+-------------------+
1 row in set (3.22 sec)mysql> select @index1 as num1,@index2 as num2;
+------+--------+
| num1 | num2 |
+------+--------+
| 10 | 122259 |
+------+--------+
1 row in set (0.01 sec)
2、楼上那位的就非常简明了!
-> union all
-> select count(*) from sendlog;
+----------+
| count(*) |
+----------+
| 10 |
| 122259 |
+----------+
2 rows in set (17.34 sec)