dave wrote:
> Hi, I'm a complete novice wtih mysql, and I'm not even 100% sure this is the
> right NG for my question - but here it goes:
>
> I want to add fields to an existing database. If I do an "insert" of a text
> file using phpmyadmin will that ADD the fields to the database, or will it
> OVERWRITE the database altogether?
>
> Thanks...
>
> Dave
>
>
>

Hi, Dave,

No problem with being new, and yes, this is the correct place.

INSERT just adds one or more new rows to the existing table.

UPDATE will alter zero or more rows, and DELETE will remove zero or more
rows - both depending on the WHERE clause.

Since you're new to it, I suggest you pick up a decent book on basic SQL
from the bookstore or a library. SQL is a language all unto itself, and
there are a lot of things you can do with it.

Alternatively, you can look for SQL tutorials on the web, but I don't
have any references to good ones at the moment. Maybe someone else can
pop in here.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================