Now a days MySQL Database is currently the most popular. The mysql database is a open source database server in existence. It is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
The MySQL has been criticizing in the past for not supporting all the features of other popular and more expensive DataBase Management Systems. The MySQL continues to improving with each release (currently version 5), and it has become widely popular with individuals and businesses of many different sizes.
What is a Database?
The database is a structure it's comes in two types:
A flat database and a relational database. And it's relational database is much more oriented to the human mind and is often preferred over the gabble-de-gook flat database that are just stored on hard drives like a text file. MySQL is a relational database.
- In a relational structured database there are tables that store data. The columns define which kinds of information will be stored in the table. An individual column must be created for each type of data you wish to store (i.e. Age, Weight, Height).
A row containing the actual values for these specified columns. and every each row will have 1 value for each and every column. For example a table with columns (Name, Age, Weight-lbs) and it could have a row with the values (Bob, 65, 165). If all this relational database talk is too confusing, don't despair.
Why we Using a Database?
The databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can group different parts of your business into separate tables to help store your information logically.
Example tables might be: Employees, Supervisors, and Customers. Each table would then contain columns specific to these three areas. To help store information related to each employee, the Employees table might have the following columns:Hire, Date, Position, Age, and Salary.