Still reading SQL in 10 Minutes, and here is the next problem, string
concatenation in SELECT queries. The book has this query and this
result. The other data is there in the table.
mysql> select vend_city+', '+vend_state+' '+vend_zip
-> from Vendors
-> order by vend_name
-> ;
+----------------------------------------+
| vend_city+', '+vend_state+' '+vend_zip |
+----------------------------------------+
| 44333 |
| 44444 |
| 99999 |
| 11111 |
+----------------------------------------+
4 rows in set (0.01 sec)
How do I do this in MySQL?
Alternatively, can anyone suggest a good tutorial for MySQL online
that covers the topics the book does? The book's web site is at
http://www.forta.com/books/0672316641/
--
Bob Rea
Fear of Hell is pernicious;
So is fear of Heaven.
[EMAIL PROTECTED] http://www.sirius.com/~rear
---------------------------------------------------------------------
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
