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…
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
More About This Author
Array
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals