質問編集履歴
1
SQL修正しました。記載ミスで実際のクエリには問題ありません。
test
CHANGED
File without changes
|
test
CHANGED
@@ -40,7 +40,7 @@
|
|
40
40
|
|
41
41
|
```SQL
|
42
42
|
|
43
|
-
INSERT INTO table_name (id,date_name,product_id,num,created_at,updated_at) VALUES(99999,2020-07-12,11111,1000,2020-07-12 08:45:08,2020-07-12 13:45:23) ON DUPLICATE KEY UPDATE num = VALUES(num),updated_at = VALUES(updated_at)
|
43
|
+
INSERT INTO table_name (id,date_name,product_id,num,created_at,updated_at) VALUES(99999,'2020-07-12',11111,1000,'2020-07-12 08:45:08','2020-07-12 13:45:23') ON DUPLICATE KEY UPDATE num = VALUES(num),updated_at = VALUES(updated_at)
|
44
44
|
|
45
45
|
```
|
46
46
|
|