質問編集履歴
4
ID名の変更。変更前は、履歴参照。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -38,9 +38,9 @@
|
|
|
38
38
|
|
|
39
39
|
WHERE
|
|
40
40
|
|
|
41
|
-
(customer_reservation.
|
|
41
|
+
(customer_reservation.id = 79)
|
|
42
42
|
|
|
43
|
-
AND (customer.
|
|
43
|
+
AND (customer.id= 79)
|
|
44
44
|
|
|
45
45
|
AND (customer_reservation.delete_flag = false)
|
|
46
46
|
|
3
SQL文の転記ミス修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -52,7 +52,7 @@
|
|
|
52
52
|
|
|
53
53
|
IN (
|
|
54
54
|
|
|
55
|
-
SELECT customer_reservation.customer_id, max(DATE_FORMAT(customer_reservation.reservation_date + ' ' + customer_reservation.reservation_starttime, '%H
|
|
55
|
+
SELECT customer_reservation.customer_id, max(DATE_FORMAT(customer_reservation.reservation_date + ' ' + customer_reservation.reservation_starttime, '%H-%k-%I %r:%T'))
|
|
56
56
|
|
|
57
57
|
|
|
58
58
|
|
2
SQL文の転記ミス修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,9 +58,7 @@
|
|
|
58
58
|
|
|
59
59
|
FROM customer_reservation
|
|
60
60
|
|
|
61
|
-
WHERE
|
|
62
|
-
|
|
63
|
-
|
|
61
|
+
WHERE (customer_reservation.delete_flag = false)
|
|
64
62
|
|
|
65
63
|
|
|
66
64
|
|
1
誤記修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,7 +14,7 @@
|
|
|
14
14
|
|
|
15
15
|
最大のレコードを抽出したいのですが、
|
|
16
16
|
|
|
17
|
-
下記では、テーブル中で、一番最初に見つけたレコードを抽出したいのですが、
|
|
17
|
+
下記では、テーブル中で、一番最初に見つけたレコードを抽出したいのですが、抽出0件です。
|
|
18
18
|
|
|
19
19
|
|
|
20
20
|
|