Remove duplicate rows in MySQL

Posted Under: Database on Mar 13, 2020
This tutorial provide snippet on how to remove duplicate rows that may have created over time. This may be a result of a spam attack or by mistakenly repeating entries. They consume precious resources of the server and decrease over all performance of any system. There are many ways to remove duplicates rows form a MySQL server.

MySQL Import Database Dump Command Line

Posted Under: Database on Mar 10, 2020
There are multiple ways to import database dumps in MySQL/MariaDB. First way to import databases it to use mysqldump utility.

MySQL Select 1st Day of Month and Current Time

Posted Under: Database on Aug 29, 2018
MySQL snippet to select data between first day of the current month and current date.

Entity Relationship Diagram (ERD) for Point of Sale System (POS)

Posted Under: Database on Nov 17, 2016
A Point of Sale or Point of Service is generally a machine which calculate the amount of item/services a customer owed to the trader. A customer can pay in cash or via a credit card.

MySQL Replace NULL With 0 in SELECT Statement

Posted Under: Database on Nov 11, 2016
When you make a Left Join or make a UNION query the DBMS will put NULL where their is no match in the set. This tutorial is aimed to discuss the options by which NULL can be substituted with 0 in MySQL DBMS.
© Tutorial Jinni