Mika Sjöman wrote:
>
> Hi...
>
> The only cause that I´m on this list is because Blueworld is makeing Lasso
> Professional 5 with built in MySQL database server.
>
> Because I am a Mac person I´m used to the powers of text string calculation
> in Filemaker pro.
> The information I have got, tells me that MySQL does not have "triggers"
> built in for the same purpose.
> Is this true?
>
> if I have three comlumns in my MySQL_DB: first_name, sur_name, age.
>
> I need to have a fourth column that is a concatenated version of this:
>
> "My name is Mika Sjøman and my age is 21"
>
> And I need it automatically to be done by the database server. Is this
> possible in MySQL?
> If there arn´t - please make a support for triggers.
>
> Warm hugs from the MacOS X community to the DW team of MySQL!
>
> Kind regards
>
> Mika Sjøman
>
Hi,
You don't need triggers for that !
Try:
select first_name,
sur_name,
age,
concat("My name is ",first_name," ",sur_name," and my age is ", age)
from ....
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
