The Ultimate Guide to High Availability with MariaDB

Comments - Use of UPDATE & SELECT operators

8 years, 3 months ago Jon Lethbridge
Re: Use of UPDATE & SELECT operators [Answer]

Hi - Thanks for the reponse.

When simulating the querey I was getting the following...

  1. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

However, with you confirming the SQL I actually ran the SQL and it worked fine. So it must be an issue with the simulator running within XAMPP which is what I am using for my local environments.

So I think I'm sorted - although a little confused.

Thanks for your quick response.

Jon.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.