質問編集履歴
1
誤字脱字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -166,9 +166,10 @@
|
|
|
166
166
|
,point_of_sale_id
|
|
167
167
|
WITH ROLLUP
|
|
168
168
|
) AS sum;
|
|
169
|
+
```
|
|
169
170
|
|
|
170
|
-
|
|
171
171
|
### ビュー
|
|
172
|
+
```SQL
|
|
172
173
|
CREATE
|
|
173
174
|
ALGORITHM = UNDEFINED
|
|
174
175
|
DEFINER = `hironobu`@`localhost`
|
|
@@ -189,5 +190,7 @@
|
|
|
189
190
|
JOIN `point_of_sales` `pos` ON ((`so`.`point_of_sale_id` = `pos`.`point_of_sale_id`)))
|
|
190
191
|
WHERE
|
|
191
192
|
(`so`.`processing_status_id` <> 8)
|
|
193
|
+
```
|
|
194
|
+
|
|
192
195
|
###補足情報(言語/FW/ツール等のバージョンなど)
|
|
193
196
|
MySQL 5.7
|