cobar
cobar copied to clipboard
Published
20 hours ago •
alibaba
alibaba
跨库join、orderbylimit 等现在支持了么？
我看邱硕的 ppt 里： 分页排序：
SELECT c1 FROM tb1 ORDER BY c1 LIMIT 4, 2
跨库join：
SELECT *
FROM tb1 INNER JOIN tb2
ON t1.MEMBER_ID=t2.NAME
WHERE t1.gmt>600
AND t2.time>600
都是ok的？
哥也是醉了：
MySQL [dbtest]> select * from tb2;
+-----+-------+
| id | val |
+-----+-------+
| 1 | part1 |
| 2 | part1 |
| 513 | part2 |
+-----+-------+
MySQL [dbtest]> select id, count(*) from tb2;
+-----+----------+
| id | count(*) |
+-----+----------+
| 1 | 2 |
| 513 | 1 |
+-----+----------+
2 rows in set (0.01 sec)
MySQL [dbtest]> select id, count(*) from tb2 where id > 0;
+-----+----------+
| id | count(*) |
+-----+----------+
| 1 | 2 |
| 513 | 1 |
+-----+----------+
2 rows in set (0.00 sec)
MySQL [dbtest]> select id, count(*) from tb2 where id < 3;
+----+----------+
| id | count(*) |
+----+----------+
| 1 | 2 |
| NULL | 0 |
+----+----------+
2 rows in set (0.00 sec)
MySQL [dbtest]> select * from tb2 where id < 3;
+----+-------+
| id | val |
+----+-------+
| 1 | part1 |
| 2 | part1 |
+----+-------+
ppt 吹得也太大了 ...
主要是没时间投入来改这些了..
