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 "...
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...
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 city. If you update your resident data, add or delete it, the graphic will change in real-time without the need to refresh from the page. Before we begin, we need to prepare: Webserver is installed,...
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...
