DEANO.ME

MySQL / SQL

 

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.

+1
Tweet
Share
Share
Stumble
Pin
Email
Shares 0