質問編集履歴
3
sql文修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -20,7 +20,7 @@
|
|
20
20
|
|
21
21
|
|
22
22
|
|
23
|
-
UPDATE favorite set time =
|
23
|
+
UPDATE favorite set time = SYSDATE() WHERE time = (SELECT MAX(time) FROM favorite WHERE user_id = 1 AND app_id = 1);
|
24
24
|
|
25
25
|
|
26
26
|
|
2
sql文再修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -20,7 +20,7 @@
|
|
20
20
|
|
21
21
|
|
22
22
|
|
23
|
-
UPDATE favorite set
|
23
|
+
UPDATE favorite set time = GETDATE() WHERE time = (SELECT MAX(time) FROM favorite WHERE user_id = 1 AND app_id = 1);
|
24
24
|
|
25
25
|
|
26
26
|
|
1
sql文修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -20,7 +20,7 @@
|
|
20
20
|
|
21
21
|
|
22
22
|
|
23
|
-
UPDATE favorite set favorite_time = GETDATE() WHERE
|
23
|
+
UPDATE favorite set favorite_time = GETDATE() WHERE time = (SELECT MAX(time) FROM favorite WHERE user_id = 1 AND app_id = 1);
|
24
24
|
|
25
25
|
|
26
26
|
|