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//
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//