I'm just starting to look at MySQL, been working w SQL Server.
I just noticed that in MySQL, you can't concatenate strings with '+', like
you can in SQL Server. In other words, in SQL Server
SELECT 'asdf' + 'qwer'
gives 'asdfqwer', but in MySQL, it gives 0. For MySQL, you seem to have to
use CONCAT.
I'm very surprised. Not only is this really really common operation much
more awkward in MySQL, but I thought string concatenation w '+' was totally
standard SQL.
Not so? Is there some db option to allow it?
Dave Merrill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
