MySQL Definitions

Database server An information storage system that is able to serve information to you.
MySQL The name of the database server that we'll use. Oracle is another common one.
Database Within MySQL you can set up multiple databases, each for a specific purpose. The database used in this class is named beernink_html.
Table Within a database, information is stored in tables. Each table contains one specific type of information such as names, addresses or articles.
Row Within a table, each name or address is stored in a row.
Column The information in a row is divided into columns. For example, a table storing names might have first, middle and last columns.
Connection Before your web page can request information from a database, it must get a connection to the database. In our examples the connection is made automatically.
Query A request to a database to store or retrieve information is called a query.

Home