Re: MySQL Syntax assistance

[Peter Brawley]

The MySQL + operator is arithmetic only; use concat() to concatenate string values/

Correlated subqueries are grossly inefficient; they should be used only where there's no alternative. Here you do have alternatives ... move them to the FROM clause!

But those correlated subqueries are FOR XML. MySQL doesn't yet support it, though it's on their study list (https://dev.mysql.com/worklog/task/?id=2410).

XML query output can be got from PHP (https://stackoverflow.com/questions/5112282/get-mysql-database-output-via-php-to-xml) or Perl (http://www.kitebird.com/articles/mysql-xml.html#TOC_2), and from the MySQL client program, but not currently directly in MySQL's SQL variant.



Edited 1 time(s). Last edit at 02/04/2021 10:42PM by Peter Brawley.