All In One Script

PHP,HTLM,CSS,Jquery,AJAX,Javascript and etc doubts and sample codes

Home
Javascript
PHP
CSS
SQL/MYSQL

Throw an error in a MySQL Trigger

by Blogger 3:09:00 AM Error MYSQL Throw Trigger

Throw an error in a MySQL Trigger

If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table?

Solution :

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.

SHARE :

Throw an error in a MySQL trigger

by Blogger 3:08:00 AM MYSQL Throw Trigger

Throw an error in a MySQL trigger

If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table?

answer :

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.

Source :http://stackoverflow.com/questions/24/throw-an-error-in-a-mysql-trigger

SHARE :

Search This Blog

Followers

Popular
Recent
Comments

How to get Real IP,ISP,Country,City and etc from Visitor using PHP

Get first key in a (possibly) associative array?

Solved : curl_init() function not working in Ubuntu

Does finally always execute in Java?

How to efficiently iterate over each Entry in a Map?

Serving XHTML and self-closing tags

How can I make the cursor a hand when a user hovers over a list item?

Window clearTimeout() Method

How to check whether a checkbox is checked in jQuery?

How to check if PHP array is associative or sequential?

Instagram

About

Popular Posts

How to get Real IP,ISP,Country,City and etc from Visitor using PHP

How to get Real IP,ISP,Country,City and etc from Visitor using PHP Php Get Real visiter's IP and ISP and Country and City and Countr...
Get first key in a (possibly) associative array?

Get first key in a (possibly) associative array? What's the best way to determine the first key in a possibly associative array? My...
Solved : curl_init() function not working in Ubuntu

Solved : curl_init() function not working in Ubuntu Here solved the error Fatal error: Call to undefined function curl_init() ...
Does finally always execute in Java?

Does finally always execute in Java? I have a try/catch block with return s inside it. Will the finally block be called? For example...
How to efficiently iterate over each Entry in a Map?

How to efficiently iterate over each Entry in a Map? If I have an object implementing the Map interface in Java and I wish to iterate...
Serving XHTML and self-closing tags

Serving XHTML and self-closing tags I am trying to follow the xhtml 1.0 strict standard as I am creating my website. Right now, validat...
How can I make the cursor a hand when a user hovers over a list item?

How can I make the cursor a hand when a user hovers over a list item? I've got a list, and I have a click handler for its items: ...
Window clearTimeout() Method

Window clearTimeout() Method Definition and Usage The clearTimeout() method clears a timer set with the setTimeout() method. ...
How to check whether a checkbox is checked in jQuery?

How to check whether a checkbox is checked in jQuery? I need to check the checked property of a checkbox and perform an action based ...
How to check if PHP array is associative or sequential?

How to check if PHP array is associative or sequential? PHP treats all arrays as associative, so there aren't any built in function...

statcounter

web statistics

web statistics

statcounter

web statistics

web statistics

Template Created By ThemeXpose & Blogger Templates