From: Steffan A. Cline (steffanhldns.com)
Date: Sun Oct 07 2007 - 14:26:46 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
SteffanExecuChoice.net Phoenix, Az
http://www.ExecuChoice.net USA
AIM : SteffanC ICQ : 57234309
YAHOO : Steffan_Cline MSN : steffanhldns.com
GOOGLE: Steffan.Cline Lasso Partner Alliance Member
---------------------------------------------------------------

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]