Throw an error preventing a table update in a MySQL trigger(在 MySQL 觸發器中引發阻止表更新的錯誤)
<![CDATA[<tfoot id='0C5fL'></tfoot>]]> <![CDATA[<bdo id='0C5fL'></bdo><ul id='0C5fL'></ul>]]>
<![CDATA[<i id='0C5fL'><tr id='0C5fL'><dt id='0C5fL'><q id='0C5fL'><span id='0C5fL'><b id='0C5fL'><form id='0C5fL'><ins id='0C5fL'></ins><ul id='0C5fL'></ul><sub id='0C5fL'></sub></form><legend id='0C5fL'></legend><bdo id='0C5fL'><pre id='0C5fL'><center id='0C5fL'></center></pre></bdo></b><th id='0C5fL'></th></span></q></dt></tr></i>]]> <![CDATA[<div class="qwawimqqmiuu" id='0C5fL'><tfoot id='0C5fL'></tfoot><dl id='0C5fL'><fieldset id='0C5fL'></fieldset></dl></div>]]>
<![CDATA[<tbody id='0C5fL'></tbody>]]> <![CDATA[<small id='0C5fL'></small><noframes id='0C5fL'>]]>
<![CDATA[<legend id='0C5fL'><style id='0C5fL'><dir id='0C5fL'><q id='0C5fL'></q></dir></style></legend>]]>
本文介紹了在 MySQL 觸發器中引發阻止表更新的錯誤的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！
問題描述
如果我在更新表之前有一個觸發器，我該如何拋出阻止更新該表的錯誤?
If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table?
推薦答案
這是一個可行的黑客.它不干凈，但看起來可能有用:
Here is one hack that may work. It isn't clean, but it looks like it might work:
本質上，您只是嘗試更新不存在的列.
Essentially, you just try to update a column that doesn't exist.
這篇關于在 MySQL 觸發器中引發阻止表更新的錯誤的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！
【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！
