DEANO.ME

SQL

 

In August 2014 I started an article on improving the speed and performance of your OpenCart store by improving your OpenCart database indexing, shockingly it appears OpenCart did not set required indexes that are vital for larger OpenCart stores. MySQL uses indexes to speed up queries, every join or search using an index is cached […]

 

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.