回答編集履歴
1
test
CHANGED
@@ -1,59 +1,26 @@
|
|
1
1
|
INFORMATION_SCHEMAを使うのがよいでしょうね。
|
2
2
|
|
3
|
-
|
4
|
-
|
5
|
-
```lang-<ここに言語を入力>
|
6
|
-
|
7
3
|
SELECT
|
8
|
-
|
9
4
|
CONCAT(
|
10
|
-
|
11
5
|
'SELECT id, Q, ', GROUP_CONCAT(COLUMN_NAME), ' FROM Quiz') AS stmt
|
12
|
-
|
13
6
|
FROM
|
14
|
-
|
15
7
|
(SELECT
|
16
|
-
|
17
8
|
COLUMN_NAME
|
18
|
-
|
19
9
|
FROM
|
20
|
-
|
21
10
|
INFORMATION_SCHEMA.COLUMNS
|
22
|
-
|
23
11
|
WHERE
|
24
|
-
|
25
12
|
TABLE_NAME='Quiz'
|
26
|
-
|
27
13
|
AND
|
28
|
-
|
29
14
|
COLUMN_NAME NOT IN ('id', 'Q' )
|
30
|
-
|
31
15
|
ORDER BY RAND()) AS randomCols;
|
32
|
-
|
33
|
-
```
|
34
|
-
|
35
|
-
|
36
|
-
|
37
16
|
|
38
17
|
|
39
18
|
この結果はSQL文で実行するたびに異なる結果を返します。
|
40
19
|
|
41
|
-
|
42
|
-
|
43
|
-
```lang-<ここに言語を入力>
|
44
|
-
|
45
20
|
SELECT id, Q, answer,dummy4,dummy1,dummy3,dummy2 FROM Quiz
|
46
|
-
|
47
21
|
SELECT id, Q, dummy4,dummy3,answer,dummy2,dummy1 FROM Quiz
|
48
|
-
|
49
22
|
SELECT id, Q, dummy3,answer,dummy4,dummy2,dummy1 FROM Quiz
|
50
|
-
|
51
23
|
:
|
52
|
-
|
53
|
-
```
|
54
|
-
|
55
|
-
|
56
24
|
|
57
25
|
これでいけると思います。
|
58
26
|
|
59
|
-
|