質問編集履歴
3
質問内容の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
|
11
11
|
```
|
12
12
|
|
13
|
-
INSERT INTO table (user_id, date, val) VALUES
|
13
|
+
INSERT INTO test_table (user_id, date, val) VALUES
|
14
14
|
|
15
15
|
((select id from users where user_name = 'user1'),'2019-06-10',1),
|
16
16
|
|
2
質問内容の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
|
11
11
|
```
|
12
12
|
|
13
|
-
INSERT INTO table (user_id, date, val
|
13
|
+
INSERT INTO table (user_id, date, val) VALUES
|
14
14
|
|
15
15
|
((select id from users where user_name = 'user1'),'2019-06-10',1),
|
16
16
|
|
@@ -18,7 +18,7 @@
|
|
18
18
|
|
19
19
|
((select id from users where user_name = 'user3'),'2019-06-10',3),
|
20
20
|
|
21
|
-
ON DUPLICATE KEY UPDATE
|
21
|
+
ON DUPLICATE KEY UPDATE val=VALUE(val);
|
22
22
|
|
23
23
|
```
|
24
24
|
|
1
質問内容の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,7 +1,3 @@
|
|
1
|
-
a x b に複合インデックスでユニーク制約をつけてあって
|
2
|
-
|
3
|
-
|
4
|
-
|
5
1
|
users テーブルに PK: id と user_name というカラムをもっていて
|
6
2
|
|
7
3
|
|