56,681
社区成员
发帖
与我相关
我的任务
分享
select *,16 as tableNumber from merger_16 where gridID in (55162406,55162407,55162408,55180406,55180407,55180408,55198406,55198407,55198408) order by ((lon-104.079048)*(lon-104.079048)+(lat-30.658125)*(lat-30.658125)) asc
select count(*) from(select *,16 as tableNumber from merger_16 where gridID in (55162406,55162407,55162408,55180406,55180407,55180408,55198406,55198407,55198408) order by ((lon-104.079048)*(lon-104.079048)+(lat-30.658125)*(lat-30.658125)) asc) t
mysql> select * from calendar;
+------------+
| d |
+------------+
| 2006-11-01 |
| 2006-11-02 |
| 2006-11-03 |
| 2006-11-04 |
| 2006-11-05 |
| 2006-11-06 |
| 2006-11-07 |
| 2006-11-08 |
| 2006-11-09 |
| 2006-11-10 |
| 2006-11-11 |
| 2006-11-12 |
| 2006-11-13 |
| 2006-11-14 |
| 2006-11-15 |
| 2006-11-16 |
| 2006-11-17 |
| 2006-11-18 |
| 2006-11-19 |
| 2006-11-20 |
+------------+
20 rows in set (0.00 sec)
mysql> select * from calendar order by d limit 10,5;
+------------+
| d |
+------------+
| 2006-11-11 |
| 2006-11-12 |
| 2006-11-13 |
| 2006-11-14 |
| 2006-11-15 |
+------------+
5 rows in set (0.00 sec)
mysql> select FOUND_ROWS() ;
+--------------+
| FOUND_ROWS() |
+--------------+
| 15 |
+--------------+
1 row in set (0.03 sec)
mysql>
mysql> select SQL_CALC_FOUND_ROWS * from calendar order by d limit 10,5;
+------------+
| d |
+------------+
| 2006-11-11 |
| 2006-11-12 |
| 2006-11-13 |
| 2006-11-14 |
| 2006-11-15 |
+------------+
5 rows in set (0.00 sec)
mysql> select FOUND_ROWS() ;
+--------------+
| FOUND_ROWS() |
+--------------+
| 20 |
+--------------+
1 row in set (0.00 sec)
mysql>
select count(*) from (
select *,16 as tableNumber
from merger_16 where gridID in
(55162406,55162407,55162408,55180406,55180407,55180408,55198406,55198407,55198408)
and kind like '0130%'
order by
((lon-104.079048)*(lon-104.079048)+(lat-30.658125)*(lat-30.658125))
asc
) t
select *,16 as tableNumber from merger_16
where gridID in
(55162406,55162407,55162408,55180406,55180407,55180408,55198406,55198407,55198408)
and kind like '0130%'
order by
((lon-104.079048)*(lon-104.079048)+(lat-30.658125)*(lat-30.658125))
asc
limit 0,10
select count(*) from( select *,16 as tableNumber from merger_16 where gridID in (55162406,55162407,55162408,55180406,55180407,55180408,55198406,55198407,55198408) order by ((lon-104.079048)*(lon-104.079048)+(lat-30.658125)*(lat-30.658125)) asc ) t
select *,16 as tableNumber from merger_16 where gridID in
(55162406,55162407,55162408,55180406,55180407,
55180408,55198406,55198407,55198408)
order by
(
(lon-104.079048)*(lon-104.079048)
+(lat-30.658125)*(lat-30.658125)
) asc limit 10,20