This tutorial will help you understand the process of importing data into your MySQL database running on Windows and MacOS using MySQL Workbench. It will also work on Linux; However, on Linux I would like you to use Commands, as it is faster and easy way to handle the import operations. Open MySQL Workbench Open […]
MySql
Installing Configuring MySQL Workbench on Windows 10/11
1. Choosing a Setup Type: 2. Check Requirements 3. The warning 4. Installation 5. Product configuration 6. Type and Networking 7. Authentication Method 8. Accounts and Roles 9. Windows Service 10. Server File Permissions 11. Apply Configuration 12. Product Configuration 13. MySQL Router Configuraion 14. Product Configuration 15. Coneect to Server 16. Connect to Server […]
What is the difference between SQL Primary and Foreign key
This article will you detail understanding on what is primary and foreign key in SQL database and how to use them to manage relationship between two or multiple tables and also details the key difference between primary and foreign key
Change User Password by Validating Current Password in PHP MySQL
The perfect user of PHP password_hash and password_verify inbuilt functions, Learn how you can develop change login password feature along with all required validations.
3 Steps to Build efficient PHP MySQL Shopping Cart Application
Introduction Let’s learn how to develop shopping cart using PHP and MySQL, in this tutorial I am going to provide details steps along with source code on how we can build simple and best shopping cart in 10 minutes. We all know shopping cart is used to collect items at one place to submit the […]
MySQL Database Backup and Restore from Terminal
Learn how to take MySQL database backup using terminal from server and Restore or migrate the database using terminal with mysqldump command