Quote
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 into it.
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.
Quote
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.
I
know 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! :-)
Quote
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.