MySQL Forums :: MySQL Workbench :: Update Query not Executing


Advanced Search

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
Update Query not Executing 417 Philip Donald 12/17/2016 12:56PM
Re: Update Query not Executing 184 Peter Brawley 12/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.