How to import Access data to Mysql

During website construction, you often need to import and export some data. In Mysql databases, there are generally two ways to process data export:
1. Use select * from table_name into outfile "file_name ";
2. Use the mysqldump utility
The following is an example:
Assume that one database in our database is samp_db, and one table is samp_table. Now we need to export the data of samp_table. We can use the following methods to achieve this:
Enter select * from samp_table into outfile "file_name" at the Mysql prompt ";
Enter mysqldump at the system command prompt