MySQL Forums
Forum List  »  MySQL Workbench

Re: Update Query not Executing
Posted by: Peter Brawley
Date: December 17, 2016 02:34PM

M$oft has been enamored with Hungarian case for forty years, but case sensitivity can be an issue in MySQL, especially on Linux, so don't use Hungarian case in MySQL identifier names. All lower case is best practice.

Another MySQL gotcha: it accepts Check syntax as a sop to ISO SQL syntax compatibility, but does not implement it.

Both update queries work with MySQL 5.7.17.

Options: ReplyQuote


Subject
Views
Written By
Posted
515
December 17, 2016 12:56PM
Re: Update Query not Executing
206
December 17, 2016 02:34PM


Sorry, you can't reply to this topic. It has been closed.

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.