请求一条 SQL 语句

[nlimpid]

dump 表，包含四个字段 id, name, phone, status

INSERT INTO dump(id, name, phone, status)
SELECT 1, "test", "111", 2
FROM dump where not exists (select * from dump where name = "test" and status = 2)limit 1

请问上面这个语句正确么？如果正确，是如何执行的。