Question: how to import data from excel 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). Tables: The list of all tables of the currently active database is shown. Select the Table from the list box.