Database is a software application used for storing, managing and retrieving information. Each data in the database are stored in tables.
Database management system:
DBMS is a computer software application that interact with the user, other applications, and the database itself to retrieve and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.
Best examples of DBMS are MySQL, PostgreSQL, Microsoft SQL Server
MySQL is the world's most popular open source database software, with over 100 million copies of its software are distributed. MySQL is a popular choice of database for use in web applications. This database system is powerful, feature-rich software, capable of organizing and searching millions of records at very high speeds.
How to start MySql:
In xampp or wamp or lamp local servers, MySql facility is included by default. Just turn on the MySql and start working.
- To start MySql in xampp, Open xampp control pannel --> Click on 'Start' near MySql.
- Now open web browser and give URL --> http://localhost/phpmyadmin/
- If phpmyadmin page is visible, then it's time to proceed your work in php with MySql.
Before Starting MySql Tutorial, we suggest you to learn SQL clearly...