Re: check two columns

[Mohamed Mansour]

Are you trying to insert into the database?
or receive?

If your recieving, please take this note:
your trigger even can be either INSERT, LOAD DATA, REPLACE, UPDATE, DELETE.

Therefore no SELECT. Use views if you want to select.

Any why wont you make a javascript or serverside check? Instead of a database check.

If your inserting, you could do this..

create a procedure that checks when if each row is null or empty

and then use your trigger to call that procedure...


Hope it helps, I recommend you to read
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
and
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

Take care, ciao