質問編集履歴
2
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -44,7 +44,7 @@
|
|
|
44
44
|
|
|
45
45
|
```sql
|
|
46
46
|
|
|
47
|
-
INSERT INTO SLEEP(employee_no, date, working_time
|
|
47
|
+
INSERT INTO SLEEP(employee_no, date, working_time)
|
|
48
48
|
|
|
49
49
|
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
50
50
|
|
1
コードの修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -46,7 +46,13 @@
|
|
|
46
46
|
|
|
47
47
|
INSERT INTO SLEEP(employee_no, date, working_time, leave_time)
|
|
48
48
|
|
|
49
|
-
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
49
|
+
VALUES (0001, '2019-05-21', '2019-05-21 07:20:00')
|
|
50
|
+
|
|
51
|
+
ON DUPLICATE KEY UPDATE
|
|
52
|
+
|
|
53
|
+
employee = values(employee)
|
|
54
|
+
|
|
55
|
+
WHERE date = '該当の日付';
|
|
50
56
|
|
|
51
57
|
```
|
|
52
58
|
|