Re: Adding new Table in existing database

Nipa wrote:

> Hi everyone,
>
> I am fairly new to the database development. I don't have any
> expirence with database.
>
> I want to create a table with 3 or more fields.
> Something similar to this:
>
> uername password testResults
> someName sompwd 0
> otherName pwd 3
> name pwd 8
>
> I am not sure how would I be able to create a table with such
> fields? In general I am not sure what does it exactly mean to
> have or to create a table in database terminology.
>
> Please provide some insight on this.
>
> Thanks
> Nipa
>
> PS: I am scripting in perl/cgi.
>

        CREATE TABLE <tablename> (<columnname> <datatype>, <columnname> <datatype>)

        where datatype depends on the RDBMS you are using.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one