Robert Fox wrote: >Hi Frank- > >I'm new to the MySQL world, and I am also a DBA with an Oracle background. >This was a surprise to me as well. However, the only solution that I know >of is to encapsulate your SELECT elements in a Concat() function. So, your >SQL statement would be: > >select concat(numer, text) >from table; > >If anyone else knows of another way to concatenate using MySQL, I'd be >interested to hear their solution. > >Rob > >At 08:46 PM 9/26/02 +0200, you wrote: > > >>Hi all, >> >>I'm a DBA in the Oracle World. >> >>I want to make a sql query in mysql, with a concat (||) known i Oracle >>world. >> >>Like this. >> >>select numer ||','|| text from Table: >> >>Where the output will be eg. >> >>1,HI >>2,Frank >> >>And so on.... >> >>Hope one of you can see my problem. I've tried the same on mysql, but it >>mess all up. >> >>Regards >>Frank >> >> >> >>--------------------------------------------------------------------- >>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 >> >> > > >--------------------------------------------------------------------- >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 > > > You may also start mysqld with --ansi to get the "||" to act as concat (amongst other ansi-isms).
See: http://www.mysql.com/doc/en/ANSI_mode.html -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.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