Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!feed2.news.rcn.net!feed1.news.rcn.net!rcn!not-for-mail
From: Jerry Gitomer <jgitomer@erols.com>
Newsgroups: comp.databases.theory
Subject: Re: Adding new Table in existing database
Date: Sat, 10 Nov 2001 22:20:19 -0500
Lines: 36
Message-ID: <9skqp1$6ls$1@bob.news.rcn.net>
References: <24d1a4c3.0111101338.7f1d53d9@posting.google.com>
Reply-To: jgitomer@erols.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
X-Trace: UmFuZG9tSVY2KKL15vNHqChrDoVcef6MFEDndYCf+kYEzgKkrrgQ7pVO1tLT1EW/
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 11 Nov 2001 03:20:01 GMT
User-Agent:  KNode/0.4
Xref: easynews comp.databases.theory:18933
X-Received-Date: Sun, 11 Nov 2001 03:13:28 MST (news.easynews.com)

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