Monday, March 11, 2024

To Read Local file from MySql

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');




No comments:

Followers

Link