Tag: mysql
NodeJS – Simple CRUD APIs with MySQL
In this article, I will do a simple CRUD APIs in NodeJS, Express and MySQL. We learn how to create restful (create, read, update, delete) api in NodeJS. API End Points, test on Postman: GET /learns: Give all learns stored in database GET /learns/{id}: Give a specific user with id. POST /learns : Create a […]
How to connect PHP to MySQL database on another server using PDO and MySQLi
If normally the source code and database are on the same hosting server, you only need to set the server name to localhost. However, in many cases where we need to use an additional database or have an external server IP range, a little setup is required on this additional server. When connecting via IP […]
Some useful MySQL query commands
This article lists some MySQL commands that may be helpful for you. I. MySQL commands 1. COUNT and GROUP BY If you want to display a list of how many tutorials are written by each user, you can use COUNT and GROUP BY. For example, we have the Blogs table as follows: SELECT operator_id, count(*) as count […]
Move large mysql database to new server
We all know the importance of a database in every system, in this article we ask you to back up, move database to another server. This will be easily handled if your db has a small number of records. And if the number of records is too large (a few million records or more) then exporting […]
Optimize your MySQL Database Performance
MySQL is a free database management system widely used in PHP. When creating tables in MySQL there are many types of Storage Engine to choose from. MyIsam & Innodb & Memory are three popular types. Choosing a store tool is extremely important before you design the database, helping to improve query performance. If the store engine […]
How to import data from excel file, csv into the database and export back
As you know, database is a very important component in every website, information is stored and manipulated on it. Assuming you need to change or upgrade the database management system, physical memory or data from a 3rd party that wants to import into your database, we have many ways to do, in this article, I […]
PHP – MVC CRUD and Connect to MySQL using PDO
Basic knowledge is always very important, in this article I will introduce to you how to use the PHP – MVC model, using PDO to connect to MySQL. What is PDO? It is an acronym for “PHP Data Objects”. Until now, the functions used were divided according to the type of database. For example: – When connecting […]
Automatically backup MySQL database with Batch file on Windows
Data backup is always very important in the way each system operates. In Linux you can easily automatically install the Crontab command, so what about Windows? We need to write code in Batch file and setup Task Schedule in Windows operating system. Very simple and fast. Task Schedule is available in Windows operating system. You […]
