Sometimes we need to quickly rebuild existed table structure. Mysql provided mysqldump options to facilitate this.
Or you can export single table in a database.
I find my program gets slower and slower when the data grows. The program is a web page crawler, when it downloaded a page and save it to MySQL database, it saved the url of the page at the same time.
When the crawler visit the target site again, it may catches the already grabbed url. The program has to search in the database to determine whether the url is already existed. A simple SQL query can do the trick.When the crawler visit the target site again, it may catches the already grabbed url. The program has to .
The MyISAM table type is an important type in MySQL, and its the default type if you not specify the type option.
MyISAM is based on old ISAM table type, it will replace the ISAM in the future.