update EMPMILL12.MCOC_LINK_FILE set desig_id=4,mc_code_id=1 where TRAN_ID=2120update EMPMILL12.MCOC_LINK_FILE set desig_id=5,mc_code_id=2 where TRAN_ID=2383update EMPMILL12.MCOC_LINK_FILE set desig_id=9,mc_code_id=3 where TRAN_ID=2121update EMPMILL12.MCOC_LINK_FILE set desig_id=11,mc_code_id=4 where TRAN_ID=2140update EMPMILL12.MCOC_LINK_FILE set desig_id=12,mc_code_id=4 where TRAN_ID=2142update EMPMILL12.MCOC_LINK_FILE set desig_id=14,mc_code_id=10 where TRAN_ID=2149update EMPMILL12.MCOC_LINK_FILE set desig_id=20,mc_code_id=11 where TRAN_ID=2147update EMPMILL12.MCOC_LINK_FILE set desig_id=26,mc_code_id=8 where TRAN_ID=2148update EMPMILL12.MCOC_LINK_FILE set desig_id=28,mc_code_id=9 where TRAN_ID=2146update EMPMILL12.MCOC_LINK_FILE set desig_id=30,mc_code_id=13 where TRAN_ID=2144update EMPMILL12.MCOC_LINK_FILE set desig_id=32,mc_code_id=12 where TRAN_ID=2145update EMPMILL12.MCOC_LINK_FILE set desig_id=33,mc_code_id=12 where TRAN_ID=2150update EMPMILL12.MCOC_LINK_FILE set desig_id=33,mc_code_id=13 where TRAN_ID=2151update EMPMILL12.MCOC_LINK_FILE set desig_id=33,mc_code_id=16 where TRAN_ID=2152update EMPMILL12.MCOC_LINK_FILE set desig_id=35,mc_code_id=16 where TRAN_ID=2153update EMPMILL12.MCOC_LINK_FILE set desig_id=37,mc_code_id=17 where TRAN_ID=2154update EMPMILL12.MCOC_LINK_FILE set desig_id=37,mc_code_id=17 where TRAN_ID=2261update EMPMILL12.MCOC_LINK_FILE set desig_id=38,mc_code_id=18 where TRAN_ID=2155update EMPMILL12.MCOC_LINK_FILE set desig_id=38,mc_code_id=18 where TRAN_ID=2262update EMPMILL12.MCOC_LINK_FILE set desig_id=39,mc_code_id=19 where TRAN_ID=2156update EMPMILL12.MCOC_LINK_FILE set desig_id=39,mc_code_id=19 where TRAN_ID=2157update EMPMILL12.MCOC_LINK_FILE set desig_id=40,mc_code_id=20 where TRAN_ID=2158update EMPMILL12.MCOC_LINK_FILE set desig_id=40,mc_code_id=20 where TRAN_ID=2159update EMPMILL12.MCOC_LINK_FILE set desig_id=41,mc_code_id=21 where TRAN_ID=2160update EMPMILL12.MCOC_LINK_FILE set desig_id=41,mc_code_id=21 where TRAN_ID=2161update EMPMILL12.MCOC_LINK_FILE set desig_id=42,mc_code_id=22 where TRAN_ID=2162update EMPMILL12.MCOC_LINK_FILE set desig_id=42,mc_code_id=22 where TRAN_ID=2163update EMPMILL12.MCOC_LINK_FILE set desig_id=44,mc_code_id=23 where TRAN_ID=2165update EMPMILL12.MCOC_LINK_FILE set desig_id=44,mc_code_id=24 where TRAN_ID=2166update EMPMILL12.MCOC_LINK_FILE set desig_id=44,mc_code_id=25 where TRAN_ID=2167update EMPMILL12.MCOC_LINK_FILE set desig_id=44,mc_code_id=25 where TRAN_ID=2168update EMPMILL12.MCOC_LINK_FILE set desig_id=44,mc_code_id=26 where TRAN_ID=2169update EMPMILL12.MCOC_LINK_FILE set desig_id=45,mc_code_id=27 where TRAN_ID=2170update EMPMILL12.MCOC_LINK_FILE set desig_id=45,mc_code_id=28 where TRAN_ID=2171update EMPMILL12.MCOC_LINK_FILE set desig_id=45,mc_code_id=28 where TRAN_ID=2172update EMPMILL12.MCOC_LINK_FILE set desig_id=46,mc_code_id=27 where TRAN_ID=2173update EMPMILL12.MCOC_LINK_FILE set desig_id=47,mc_code_id=30 where TRAN_ID=2174update EMPMILL12.MCOC_LINK_FILE set desig_id=47,mc_code_id=30 where TRAN_ID=2243update EMPMILL12.MCOC_LINK_FILE set desig_id=50,mc_code_id=31 where TRAN_ID=2175update EMPMILL12.MCOC_LINK_FILE set desig_id=50,mc_code_id=32 where TRAN_ID=2340update EMPMILL12.MCOC_LINK_FILE set desig_id=51,mc_code_id=32 where TRAN_ID=2178update EMPMILL12.MCOC_LINK_FILE set desig_id=52,mc_code_id=32 where TRAN_ID=2360update EMPMILL12.MCOC_LINK_FILE set desig_id=52,mc_code_id=31 where TRAN_ID=2181update EMPMILL12.MCOC_LINK_FILE set desig_id=52,mc_code_id=33 where TRAN_ID=2182update EMPMILL12.MCOC_LINK_FILE set desig_id=52,mc_code_id=34 where TRAN_ID=2183update EMPMILL12.MCOC_LINK_FILE set desig_id=52,mc_code_id= where TRAN_ID=2384
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 'where TRAN_ID=2384' at line 2 in C:\xampp\htdocs\xlsss\ejmoccuup.php:45 Stack trace: #0 C:\xampp\htdocs\xlsss\ejmoccuup.php(45): mysqli_query(Object(mysqli), 'update EMPMILL1...') #1 {main} thrown in C:\xampp\htdocs\xlsss\ejmoccuup.php on line 45