Category: MySQL


Difference Between Distinct and Group By [ MySQL – With Example ]

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2020/12/27

A lot of developers think that Group by and distinct works similarly when it comes to getting unique records. and they assume that the performance remains the same in both of the cases. But this is not the case. In […]


How to Configure Full-Text Stopwords & Stoplist in MySQL

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2017/09/20

Mysql stopwords is a list of most commonly used English language words like some, about, by, from, by… and much more. These stop words do not match if they are present in the search string. These stopwords are ignored in […]


A Step-by-Step Guide to Create Partitions on MySQL table

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2017/09/20

1.What is partitioning? Partitioning is a database design technique which is used to improves performance, manageability, simplifies maintenance and reduce the cost of storing large amounts of data. Partitioning can be achieved without splitting your MySQL tables by physically putting […]


Difference Between InnoDB and MyISAM

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2017/09/20

Storage engines are used to read and write data into a database. It is a very crucial design decision which you need to make when designing a database for an application(especially for a data-intensive application). MySQL supports several data storage […]


How To Import-Export Mysql/MariaDB Database Command line

By: Sunil Kumar |  In: MySQL  |  Last Updated: 2017/09/20

As a web developer, you must be aware of some basic database operations. There would be a lot of times when you need to import or export a database either you are moving your website from one host to another […]


Join more than 10,000 others Web Developers