OpenCart: Improve MySQL performance

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 […]

Search And Replace with MySQL

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 […]

How To: Duplicate Rows using SQL in MySQL

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.

Copyright © 2017 Dean Williams.

While this site provides guides, tutorials, how-to's and information, we take no responsibility for any damage that might be caused from reading, following, implementing or even thinking about the material on this website, furthermore any facts either insinuated or otherwise suggested including any opinion's are of the respected authors and it is up to you to verify and come to your own conclusions. All posts on this site are copyright of their respective owners, and should not be copied, duplicated or in any way used without written permission from Dean Williams and the respective author of the material you wish to use, Guest Posts without an author are copyright to Deano.me.

Stumble

Shares 0

MySQL / SQL