Database

Remove duplicate rows in MySQL

If in your database there are repeated rows of data or duplicate rows of data occur, you can remove the duplication easily just by using a MySQL...

Real-Time Application Dashboard with Yii2, Node.js, MySQL and Chart.js

In this article we will create a dashboard that can display graphics from data in real-time. The data we use as simulations is the population of a...

Script Insert Thousands of Random Data into MySQL

When we create applications that use databases, of course, we need database simulations as in real conditions. With this simulation, we want to...
Remove duplicate rows in MySQL

Remove duplicate rows in MySQL

If in your database there are repeated rows of data or duplicate rows of data occur, you can remove the duplication easily just by using a MySQL script. In this article, we will learn to remove duplicate data rows from MySQL by using a script that we will run using phpMyAdmin. Prepare sample data table Before we start, set up a table named "...

Script Insert Thousands of Random Data into MySQL

Script Insert Thousands of Random Data into MySQL

When we create applications that use databases, of course, we need database simulations as in real conditions. With this simulation, we want to measure the performance of the application we are building. Both under ideal and extreme conditions.In this article, Bardimin will share an easy way by using a script to insert thousands of random data...

Create real-time applications with Node.js and MySQL

Create real-time applications with Node.js and MySQL

In the previous example, Creating a real-time application with Node.js data was not stored permanently. This means that every time the Node server.js we restart, the data will be empty again. To be able to store the inputted data, we must use a database. In this article, we will use the mySQL database that is already quite famous. The same...