SQL helps you connect to tables. So what a table? Most tables that you will be dealing with in WordPress or other websites will be relational. Relational databases and system contain one or more tables, which are a type of object. The information or data for the database is stored in these tables. Tables are identified by their names and each tables name must be unique. Each table is composed of rows and columns. Columns contain the column name, data type, and any other attributes related to the column. Rows contain the data with one record per row.
Here is a sample table called “movies.”
Movie, Year, and Rating are the columns. The rows contain the data for this table:
|A Christmas Carol||2009||5|
|A Christmas Carol||1951||7|
|The Muppet Christmas Carol||1992||10|
|Mickey's Christmas Carol||1983||9|
|A Christmas Carol||1914||3|