MySQL Forums
Forum List  »  Stored Procedures

Re: MySQL Syntax assistance
Posted by: Peter Brawley
Date: February 04, 2021 12:56PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
117
February 04, 2021 09:39AM
Re: MySQL Syntax assistance
45
February 04, 2021 12:56PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.