How to import multiple excel files into mysql database using python

Many popular database management tools ,such as Navicat ,Dbeaver, or mysql workbench don’t provide the ability to import multiple files from their user interface. If you don't want to manually import files one by one, check this video, this should be a more efficient way.