回答編集履歴
2
調整
test
CHANGED
|
@@ -14,7 +14,9 @@
|
|
|
14
14
|
|
|
15
15
|
sub2 int,
|
|
16
16
|
|
|
17
|
-
sum int as (sub1+sub2),
|
|
17
|
+
sum int as (sub1+sub2),
|
|
18
|
+
|
|
19
|
+
index(sum));
|
|
18
20
|
|
|
19
21
|
insert into tbl(name,sub1,sub2) values
|
|
20
22
|
|
|
@@ -35,3 +37,5 @@
|
|
|
35
37
|
select * from tbl order by sum desc;
|
|
36
38
|
|
|
37
39
|
```
|
|
40
|
+
|
|
41
|
+
生成列にはインデックスも貼れます
|
1
調整
test
CHANGED
|
@@ -4,7 +4,17 @@
|
|
|
4
4
|
|
|
5
5
|
```SQL
|
|
6
6
|
|
|
7
|
+
create table tbl(
|
|
8
|
+
|
|
9
|
+
id int primary key auto_increment,
|
|
10
|
+
|
|
11
|
+
name varchar(10),
|
|
12
|
+
|
|
13
|
+
sub1 int,
|
|
14
|
+
|
|
15
|
+
sub2 int,
|
|
16
|
+
|
|
7
|
-
|
|
17
|
+
sum int as (sub1+sub2),index(sum));
|
|
8
18
|
|
|
9
19
|
insert into tbl(name,sub1,sub2) values
|
|
10
20
|
|