Database terms

You need to know the main terms related to MySQL and databases in general:

• Database – a container for a collection of MySQL data.
• Table – a subcontainer within a database that stores the actual data.
• Column – a name of a field within a row.
• Row – a single record within a table.
• Primary key – a key that uniquely identifies each record in a database table.
• Foreign key – a key in one table that points to a Primary key in another table.
• Index – a special lookup table that the database search engine use to speed up data retrieval.