Category: MySQL


MySQL: Get next auto increment value of a table

Some time ago, I needed to get the auto increment value for the next inserted row in a MySQL table. As the first solution, I was thinking to get maximum of ‘id’ field and...


Import/Export MySQL Database using command line

People often use phpMyAdmin to work with MySQL. It is a nice GUI tool to manipulate database very easily. But sometimes, it won’t work with some lengthy operations such as importing and exporting large...