MySQL Snippets: Update Statement

MySQL LogoThis post is part of the series on MySQL Snippets.

The following MySQL snippet shows an example UPDATE statement for MySQL; I’m posting this as I have trouble remembering that the order of the MySQL statement is different to that of Microsoft SQL Server; in MySQL the SET clause comes after the JOIN clause, whereas in Microsoft SQL Server, with which I am more experienced, the order is…

Continue Reading azurecurve’s Article on their blog

MySQL Snippets: Update Statement

This post is part of the series on MySQL Snippets. The following MySQL snippet shows an example UPDATE statement for MySQL; I’m posting this as I have trouble remembering that the order of the MySQL statement is different to that of Microsoft SQL Server; in MySQL the SET clause comes after the JOIN clause, whereas in Microsoft SQL Server, with which I am more experienced, the order is reversed.

Blog Syndicated with azurecurve’s Permission

Author: Ian Grieve

Share This Post On