回答編集履歴
2
一寸修正
answer
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
n.i AS col2
|
|
5
5
|
,COUNT(*) AS "レコード数"
|
|
6
6
|
FROM
|
|
7
|
-
(SELECT @i := @i + 1 AS i FROM any_table, (SELECT @i :=
|
|
7
|
+
(SELECT @i := @i + 1 AS i FROM any_table, (SELECT @i := -1) n LIMIT 10) n
|
|
8
8
|
LEFT JOIN testtable1 t ON n.i = t.col2
|
|
9
9
|
WHERE
|
|
10
10
|
t.col1 = 'Tanaka'
|
|
@@ -12,4 +12,4 @@
|
|
|
12
12
|
n.i
|
|
13
13
|
;
|
|
14
14
|
```
|
|
15
|
-
any_tableには、レコードが
|
|
15
|
+
any_tableには、レコードが10件以上ある適当なテーブルを指定して下さい。
|
1
一寸訂正
answer
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
n.i AS col2
|
|
5
5
|
,COUNT(*) AS "レコード数"
|
|
6
6
|
FROM
|
|
7
|
-
(SELECT @i := @i + 1 AS i FROM any_table, (SELECT @i:=0) n LIMIT 9) n
|
|
7
|
+
(SELECT @i := @i + 1 AS i FROM any_table, (SELECT @i := 0) n LIMIT 9) n
|
|
8
8
|
LEFT JOIN testtable1 t ON n.i = t.col2
|
|
9
9
|
WHERE
|
|
10
10
|
t.col1 = 'Tanaka'
|