sql同时删除多张表的数据/sql查询百分比

https://blog.csdn.net/qq_32793985/article/details/114651944

DELETE
a,
b,
c
FROM
A a
LEFT JOIN B b ON a.bId = b.id
LEFT JOIN C c ON a.cId = c.id
WHERE
-- 需要删除数据
a.id = '666'
-- 可以设置 a/b/c 表的限制条件
AND b.type ='1'
AND c.type ='2'

sql查询百分比

SELECT
CONCAT( CAST( round( ( 6 / 100 ) * 100, 3 ) AS CHAR ), '%' ) '占比'
FROM
busa_xm_room;