回答編集履歴
1
修正
test
CHANGED
|
@@ -8,6 +8,8 @@
|
|
|
8
8
|
|
|
9
9
|
SET @a=2000;
|
|
10
10
|
|
|
11
|
-
UPDATE set ID=(@a:=@a+1) WHERE ID BETWEEN 800 AND 1000 ORDER BY ID ASC;
|
|
11
|
+
UPDATE テーブル set ID=(@a:=@a+1) WHERE ID BETWEEN 800 AND 1000 ORDER BY ID ASC;
|
|
12
12
|
|
|
13
13
|
```
|
|
14
|
+
|
|
15
|
+
※修正しました
|