Category: Database

The Debuggers presents you articles on database, how to optimize database, performance tuning of database, useful tips, debugging and so on. Keep reading.

Bulk Insert Update into MySQL using PHP

Sometimes we need to insert large data set into database table. Using one INSERT statement per row is quite inefficient. Instead of this, we can assemble one INSERT statement with multiple rows.

In this article, I am going to show how to perform bulk insert into MySQL table using PHP.

Introduction to Database Management System (DBMS)

DBMS is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. DBMS allow the definition, creation, querying, update, and administration of databases. Some of the popular DBMSs are MySQL, Oracle, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB.