I created a simple 3 row 2 column database with CREATE TABLE...commands.
You created a database table
with 3 columns
and inserted two rows
A Database is a container that can hold many Tables.
A Table is a structure made up of Columns (a.k.a. Fields). Each Row has the same structure.
A Table can have many Rows inserted into it.
Then if I add more rows and columns to the same database ...
You can add Tables to Databases.
You can add Columns to Tables (changing their structure).
You can insert Rows into Tables.
it sounds picky when you're just trying to get to grips with the ideas, but the words we use to describe things really do
matter, especially when we're trying to explain things to one another
... which is, basically, all
we do around here! :-)
It keeps giving an Error that database already exists.
That sounds like you're executing the "create database" command again.
If you get an error like this, show us the command you're running as well as the error message. It helps.
Regards, Phill W.