MySQL Forums
Forum List  »  Newbie

Re: SQL database not updating when Query is modified
Posted by: Phillip Ward
Date: February 06, 2023 08:46AM


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.


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! :-)


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.

Options: ReplyQuote

Written By
Re: SQL database not updating when Query is modified
February 06, 2023 08:46AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.