note 130417 added to mysqli.multi-query

Follow-up about MySQL warnings with multi_query(): Although get_warnings() will not work with multi_query(), this doesn't totally prevent retrieval of the warnings. The workaround is to splice ';SHOW WARNINGS;' between every query. This is necessary because the warning count(s) won't be returned until after the queries are already sent and executed. With that little workaround, every 2nd result set will be a warning list from the previous query. This adds some overhead that isn't necessary in production, but can be vital for debugging any use of multi_query() during development. Conclusion: If you need to see or log query warning strings then you can either avoid multi_query() or you can manually pull the warning list after every query. ---- Server IP: 45.112.84.4 Probable Submitter: 80.90.5.137 (proxied: 2601:803:c600:36c:644f:36a4:351d:8c41) ---- Manual Page -- https://php.net/manual/en/mysqli.multi-query.php Edit -- https://main.php.net/note/edit/130417 Del: integrated -- https://main.php.net/note/delete/130417/integrated Del: useless -- https://main.php.net/note/delete/130417/useless Del: bad code -- https://main.php.net/note/delete/130417/bad+code Del: spam -- https://main.php.net/note/delete/130417/spam Del: non-english -- https://main.php.net/note/delete/130417/non-english Del: in docs -- https://main.php.net/note/delete/130417/in+docs Del: other reasons-- https://main.php.net/note/delete/130417 Reject -- https://main.php.net/note/reject/130417 Search -- https://main.php.net/manage/user-notes.php