From the course: MySQL Essential Training

Unlock this course with a free trial

Join today to access over 23,700 courses taught by industry experts.

Database organization

Database organization - MySQL Tutorial

From the course: MySQL Essential Training

Start my 1-month free trial Buy for my team

Database organization

“

- [Bill] Hi, I'm Bill Weinman. MySQL is a relational database management system. The purpose of a database management system is to organize your data and to make it available in convenient forms. A relational database has tables. It could have one table or many tables. In this example, the database has three tables, customer, item, and sale. A table has rows and columns. In this example, the customer table has three rows and six columns. The columns are named id, name, address, city, state, and zip. A row is like an individual record in a table. In fact, some will use the term record interchangeably with row. In this example, the highlighted row is the record for Mary Smith in the customer table. A column is like a field. Again, some will use the term field interchangeably with column. In this example, the highlighted column is named address, and contains an address for each row in the table. Each row in a table has a unique key. The table's unique key may or may not correspond with a…

Contents