34,333
edits
Changes
no edit summary
The chances are that if you have ever logged into a web site or purchased an item on the internet you have interacted with a database in some way. Anything that involves the retreval or storage of information on a computer system is most likely to involve a database. In fact, databases are the core of just about every application that relies on data of some form to complete a task.
The first step in learning MySQL is to understand the difference between a ''database'' and a ''database management system (DBMS)''. The term ''database'' refers to the entity which stores the actual data (such as ID numbers, names and address for example) in a structured way. A ''database management system (DBMS)'' on the other hand, refers to the software used to store, access and manipulate the data stored in the ''database''. All interactions with the database are always performed via the ''DBMS''.
Modern databases and database management systems are not restricted to storing just text. Today, databases are used to store such items images, videos and software objects.
== Primary Keys ==
Each database table must contain one or more columns that can be used to uniquely identify each row in the table. This is known in database terminology as the ''Primary Key''. For example, a table may use the bank account number column as the primary key. Alternatively, a customer table may use the customer's social security number of the primary key.
Primary keys allow the database management system to uniquely identify a specific row in a table. Without a primary key it would not be possible to retrieve or delete a specific row in a table because there can be no certainty that the correct row has been selected. For example, suppose a table existed where the customer's last name had been defined as the primary key. Imagine then the problem that might arise if more than one customer called "Smith" was recorded in the database. Without some guaranteed way to uniquely identify a specific row it would be impossible to ensure the correct data was being accessed at any time.
Primary keys can comprise a single column or multiple columns in a table. To qualify as a single column primary key, no two rows can contain matching primary key values. When using multiple columns to construct a primary key, individual column values do not need to be unique, but all the columns combined ''must be unique''.
Finally, whilst primary keys are not mandatory in database tables their use is strongly recommended.
