Home | Store | osCommerce Tutorials

What is MySQL

MySQL is a database. The data in MySQL database is stored in tables. And the tables have records and fields. A database can be illustrated with the following schematic diagram:

Database structure

Note that:

  • a database has one or more tables, and
  • each table has a unique name.
The default osCommerce shop has one database (usually called oscommerce) and 47 tables (address_book, categories, categories_description, etc...). The default tables of osCommerce shop is shown as the diagram below:

osCommerce database tables