List:General Discussion« Previous MessageNext Message »
From:Steffan A. Cline Date:October 7 2007 7:26pm
Subject:My first trigger in MySQL
View as plain text  
I am new to triggers and am trying to figure this out. The goal I have is to
set it up so that after a row in the users table is updated it will check to
see if the affected row has a username in the username field and if not to
update that row with a concatenation of firstname + " " + lastname.

Does anyone have a good example of how to do this?




Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline 
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : steffan@stripped
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------



Thread
My first trigger in MySQLSteffan A. Cline7 Oct
  • Re: My first trigger in MySQLSteffan A. Cline7 Oct
    • Re: My first trigger in MySQLBaron Schwartz7 Oct
    • Re: My first trigger in MySQLMartijn Tonies8 Oct