22 lines
513 B
MySQL
22 lines
513 B
MySQL
|
-- 检查订单374的时长数据
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
id AS '订单ID',
|
||
|
|
order_no AS '订单号',
|
||
|
|
service_id AS '服务ID',
|
||
|
|
duration AS '时长(分钟)',
|
||
|
|
service_name AS '服务名称',
|
||
|
|
service_time AS '服务时间',
|
||
|
|
status AS '状态'
|
||
|
|
FROM work_order
|
||
|
|
WHERE id = 374;
|
||
|
|
|
||
|
|
-- 检查对应的服务信息
|
||
|
|
SELECT
|
||
|
|
id AS '服务ID',
|
||
|
|
name AS '服务名称',
|
||
|
|
duration AS '服务时长(分钟)',
|
||
|
|
price AS '价格'
|
||
|
|
FROM service
|
||
|
|
WHERE id = (SELECT service_id FROM work_order WHERE id = 374);
|