mysql to vb dot net

msankar.ravi

New member
Joined
Sep 11, 2009
Messages
1
Programming Experience
Beginner
i want to execute mysql query from vb dot net. i can able to connect mysql to vb dot net. Here i attach the code could anyone help me to how to use this code into vb dot net.

DELIMETER //

create procedure m_link ()

BEGIN

truncate Files_path;


truncate Report_2;

LOAD DATA LOCAL INFILE 'C:/Missing_link/FilesAndPath_Report.csv'
INTO TABLE Files_path
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(FileName, FilePath);

LOAD DATA LOCAL INFILE 'C:/Missing_link/Report_2.csv'
INTO TABLE Report_2
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
( no,inddname,links_name);


select distinct r.inddname, r.links_name from Report_2 r left join Files_path f on r.links_name=f.filename
where f.filename is null INTO OUTFILE 'C:\\output.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

END//
 
Back
Top