<div>
- i don't think you can skip the trigger. the workaround is to disable the trigger for that table, run your update then enable it back when the update is completed:<br />
ALTER TABLE tablename DISABLE TRIGGER ALL<br />
<br />
- run your update operation.<br />
<br />
- then enabled trigger back:<br />
ALTER TABLE tablename ENABLE TRIGGER ALL<br />

</div>


- i don't think you can skip the trigger. the workaround is to disable the trigger for that table, run your update then enable it back when the update is completed:
ALTER TABLE tablename DISABLE TRIGGER ALL

- run your update operation.

- then enabled trigger back:
ALTER TABLE tablename ENABLE TRIGGER ALL


<div>
- yes sorry about that. you need to disable it one by one and enabled it back. and thats the only way for 'not activating' the trigger while doing other processing.
</div>


- yes sorry about that. you need to disable it one by one and enabled it back. and thats the only way for 'not activating' the trigger while doing other processing.

<div>
MYSQL does not have this option but a workaround would be to put veriables to disable trigger in each trigger
</div>


MYSQL does not have this option but a workaround would be to put veriables to disable trigger in each trigger

<div>
<div class="content wysiwyg-content">
Is it anyway possible to write an update query which would not activate the trigger on that table which is being updated?<br />
&nbsp;
</div>
</div>


Is it anyway possible to write an update query which would not activate the trigger on that table which is being updated?
 

Mysql Update without triggering the trigger

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.