DELETE FROM incoices
    WHERE invoice_id = 1
    删除操作太危险了,先查后删除
    SELECT *
    FROM clients
    WHERE name = ‘Myworks’

    DELETE FROM incoices
    WHERE invoice_id = (
    SELECT *
    FROM clients
    WHERE name = ‘Myworks’
    )