LOAD DATA INFILE

With MySQL we can easily export our selected rows to the files. MySQL has several syntax which can export the retrieved rows into the file. Yes we can import these