When updating the database while on MySQL you might run across the following error:
"PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `interface_connected_asset_interface`' at line 2 in /home/helpdesk-jhuh1/helpdesk.isqu.net/database_updates.php:2349"
Reason: "IF EXISTS" found on line 2347 of the database_updates.php file is not used in MySQL and only works on MariaDB. It has been a feature request since 2005, and likely will never be added. It is seen as destructive by MySQL devs.
Solution 1: (personal) Edit line 2347 of database_updates.php to read "DROP COLUMN `interface_connected_asset_interface`". (just delete IF EXISTS) Then save the file. Run all the database updates through CLI. Then edit line 2347 of the file again to read "DROP COLUMN IF EXISTS `interface_connected_asset_interface`" (add IF EXISTS). If you don't restore the line you removed it will disable file updates.
Solution 2: (devs) If you are so inclined, you can add MySQL support for when IF EXISTS is needed by following Pradeep Puranik's method found on https://stackoverflow.com/questions/173814/using-alter-to-drop-a-column-if-it-exists-in-mysql