> For the questions... <cut> > select tekst || tekst2 total from table; > should return a virtual column called total with as value > testtest > it returns a virtual column called total alright on it's value is 0 > I also tried this with + instead of || in oracle this should give > an error > since it aren't numeric fields in mysql it does the same as || > (or atleast so it appears)
|| is a logical OR, unless you run MySQL in ANSI mode. Nothing wrong with the output. Use the CONCAT() function instead. > <cut> > these both don't work. I searched the manual but don't see UNION > at all, is > it supported? I'm figuring it isn't.... You didn't search very hard, did you? Try using the "find" command in your browser. The very first time the word UNION appears, the manual says: 1.5.4 Other Features Available From MySQL 4.0.0 ... Many users will also be happy to learn that MySQL now supports the UNION statement, a long awaited standard SQL feature. > SQL> SELECT * FROM FOOTBALL > 2 INTERSECT > 3 SELECT * FROM SOFTBALL; > > doesn't work either, i'm guessin intersect isn't implemented either? Same procedure gives you (very first hit, too): 1.9.3 Things That Have to be Done Sometime ... MINUS, INTERSECT and FULL OUTER JOIN. (Currently UNION (in 4.0) and LEFT OUTER JOIN are supported) / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
