Question: how to import excel file to mysql using sqlyog?
Answer: To import data from a CSV file into a MySQL table, select the table in Object Browser and select Table -> Import -> Import CSV Data Using Load Local... or(Ctrl+Shift+M).