<div>
in MYSQL, triggers are &quot;for each row&quot;:<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html</a><br />
<br />
so, you cannot see inside the trigger if there are several rows being updated.<br />
<br />
what you should do is to create a unique index or unique constraint on username + hobbyname, so an update cannot udpate all the rows from 1 username to the same hobby ...
</div>


in MYSQL, triggers are "for each row":
http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html [http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html]

so, you cannot see inside the trigger if there are several rows being updated.

what you should do is to create a unique index or unique constraint on username + hobbyname, so an update cannot udpate all the rows from 1 username to the same hobby ...

<div>
ok thanks Sandeepratan<br />
I'll try
</div>


<div>
This question has been classified as abandoned and is being closed as part of the Cleanup Program. &nbsp;See my comment at the end of the question for more details.
</div>


This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
Please help me providing trigger in mysql that prevent update of some particular record in a table.<br />
<br />
For example :<br />
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Hobby<br />
------------- &nbsp; &nbsp; &nbsp;-----------<br />
Willy &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Swimming<br />
Willy &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Singing<br />
Susan &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Reading<br />
Marie &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Reading<br />
Susan &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Swimming<br />
Michael &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Soccer<br />
<br />
As you can see Susan has 2 hobbies. I want to prevent update if there is a query that update all record with Susan as name.<br />
<br />

</div>
</div>


Dear All,

Please help me providing trigger in mysql that prevent update of some particular record in a table.

For example :
Name             Hobby
-------------      -----------
Willy                Swimming
Willy                Singing
Susan             Reading
Marie               Reading
Susan             Swimming
Michael            Soccer

As you can see Susan has 2 hobbies. I want to prevent update if there is a query that update all record with Susan as name.



Trigger to prevent update in Mysql

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.