Skip error and proceed execution of Mysqli::multi_query

Question

Can I to skip errors and/or proceed execution of multi_query or I must to separate my big request and execute queries in query() individually? I execute such operators as CREATE VIEW, CREATE TABLE, CREATE PROCEDURE, etc. For example, I'm not very interesting, was TABLE created, or there was some FK constraint error, or VIEW has select from other schema which not exists, etc. I just want to show error output in STDERR and execute next operator after failed or successfully completed statement.

Answer 1

I assume you are talking about an error raised on a query when running multi queries stops the whole execution...

Add IGNORE, for example

INSERT IGNORE into ...;
UPDATE IGNORE ...;

IGNORE will prevent the raised error from stopping the multi-query process