Recently I worked with a client that wanted to export a MS Access DB into MySQL, the conversion was done by a third-party but I was asked to confirm that all the data from the tables was present in PHPMyAdmin. The easiest solution to this was to compare how many records were in each table, […]


OpenCart is an awesome eCommerce system, however there are a few shortcomings due to the apparent lack of knowledge the OpenCart development team have (or perhaps the incompleteness of the OpenCart software?). Unfortunately the database structure of OpenCart does not implement MySQL indexing as it should, the database design however is extremely well implemented and […]


MySQL is a very powerful database management system with many useful features, there comes a time when you may need to search through a MySQL database and replace certain data which may now be out of date, the horrible thing is this data is repeated in many (and perhaps unknown) places throughout the tableā€¦ So […]


Are you looking to simply duplicate existing rows in your MySQL table? I needed to do this recently for a database I had for a project I was developing, I wanted to duplicate the data in the database to about 10,000 rows to test response times of SQL and perform optimization on the system.