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