PHP MySQL Introduction
MySQL is the most popular open source database server.
What is MySQL?
MySQL is the most popular open source database server.
What is MySQL?
-
MySQL is a database. A database defines a structure for storing information.
In a database, there are tables. Just like HTML tables, database tables contain rows, columns, and cells. - Databases are useful when storing information categorically. A company may have a database with the following tables: "Employees", "Products", "Customers" and "Orders".
- Database Tables:
- A database most often contains one or more tables. Each table has a name (e.g. "Customers" or"Orders"). Each table contains records (rows) with data. Below is an example of a table called "Persons":
LastName | FirstName | Address | City |
Hansen | Ola | Timoteivn10 | Sandnes |
Svendson | Tove | Borgvn 23 | Sandnes |
Pettersen | Kari | Storgt20 | Stavanger |
- The table above contains three records (one for each person) and four columns (LastName,FirstName, Address, and City)
0 comments:
Post a Comment