LOAD statement: Use the xp_mongoshell function in MSSQL to generate the mysql LOAD statement for the specified file in the specified folder.

LOAD statement: Use the xp_mongoshell function in MSSQL to generate the mysql LOAD statement for the specified file in the specified folder.

Declare @ SQL varchar (4000), @ dirpath varchar (1024), @ file_type varchar (16), @ target_table varchar (256); select @ target_table = ''adconversions '. 'app _ adcreative_device_mapping_conversion' ', @ dirpath = 'd: \ cv', @ file_type = '. tsv', @ SQL = 'dir' + @ dirpath + '/B/A'; if OBJECT_ID ('tempdb .. # temp ') is not nulldrop table tempdb .. # tempcreate table # temp (dirfile nvarchar (255); insert into # temp exec xp_cmdshell @ SQL; select 'Load DATA LOCAL INFILE ''' + REPLACE (@ dirpath, '\', '\') + '\' + dirfile + '''into table' + @ target_table + 'character SET utf8; 'As ExeSqlfrom # temp where dirfile like '%' + @ file_type;