1. Right click on Connection
2. click on Edit
3. Go to Advance
4. Add this OPT_LOCAL_INFILE=1
5. close
SHOW GLOBAL VARIABLES LIKE 'local_infile';
SET GLOBAL local_infile = true;
drop temporary table if exists temp_vin_list;
create temporary table temp_vin_list(VinNumber varchar(100));
LOAD Data Local INFILE 'D:\\Sphere\\Report\\Input\\2024-03-14\\Vin.txt' INTO TABLE temp_vin_list;
call CheckVinNumber('2024-03-14');
call CheckVinNumbersWhichAreNotExistInDB('2024-03-14');
