SQL database not updating when Query is modified

[Syed Huq]

I am a newbie and learning SQL.
I created a simple 3 row 2 column database with CREATE TABLE...commands.
I used SELECT * FROM name_of_database and everything works as it should.

Then if I add more rows and columns to the same database and try to re-do the SELECT command, the results do not show the new added entries. It keeps giving an Error that database already exists.

Why doesn't the database update itself when new entries are added ?

Syed