質問編集履歴
3
fix
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
2
fix
test
CHANGED
File without changes
|
test
CHANGED
@@ -68,7 +68,7 @@
|
|
68
68
|
|
69
69
|
select * from items i where i.id in (
|
70
70
|
|
71
|
-
select JSON_EXTRACT(item, '$.item_ids') from weapons w where w.id=1
|
71
|
+
select JSON_EXTRACT(item, '$.item_ids') from weapons w where w.id=1
|
72
72
|
|
73
73
|
);
|
74
74
|
|
1
fix
test
CHANGED
File without changes
|
test
CHANGED
@@ -36,7 +36,7 @@
|
|
36
36
|
|
37
37
|
INSERT INTO `weapons` (`id`, `item`) VALUES
|
38
38
|
|
39
|
-
(1, '[1,2]');
|
39
|
+
(1, '{"item_ids":[1,2]}');
|
40
40
|
|
41
41
|
```
|
42
42
|
|
@@ -68,7 +68,7 @@
|
|
68
68
|
|
69
69
|
select * from items i where i.id in (
|
70
70
|
|
71
|
-
select JSON_EXTRACT(item, '$') from weapons w where w.id=1
|
71
|
+
select JSON_EXTRACT(item, '$.item_ids') from weapons w where w.id=1;
|
72
72
|
|
73
73
|
);
|
74
74
|
|