質問編集履歴
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -21,7 +21,7 @@
|
|
|
21
21
|
### コードの例
|
|
22
22
|
|
|
23
23
|
```sql
|
|
24
|
-
INSERT INTO SLEEP(employee_no, date, working_time
|
|
24
|
+
INSERT INTO SLEEP(employee_no, date, working_time)
|
|
25
25
|
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
26
26
|
ON DUPLICATE KEY UPDATE
|
|
27
27
|
employee = values(employee)
|
1
コードの修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -22,7 +22,10 @@
|
|
|
22
22
|
|
|
23
23
|
```sql
|
|
24
24
|
INSERT INTO SLEEP(employee_no, date, working_time, leave_time)
|
|
25
|
-
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
25
|
+
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
26
|
+
ON DUPLICATE KEY UPDATE
|
|
27
|
+
employee = values(employee)
|
|
28
|
+
WHERE date = '該当の日付';
|
|
26
29
|
```
|
|
27
30
|
|
|
28
31
|
```sql
|