In this article, I will demonstrate how to establish a connection with SQL and perform various CRUD operations in a few simple and easy steps. I will be using phpMyAdmin as MySQL database.
phpMyAdmin has a very good UI/UX where we can easily create a new database, new table, insert multiple values to columns at a time, can change and add a primary /foreign key, export/import complete database, etc with few clicks.
In order to run phpMyAdmin server, we need to download XAMPP. …