Ad:

Database Design Discussion Thread
Unsolved
Views: 12461

Apr 23rd, 2005

Add an attribute to existing table

Expand Post »

I am supposed to write an query which will add new attribute to my already existing table
So I written this

ALTER TABLE member
ADD e_mail CHAR(20)

which is fine, however when I try insert required data for each row I get stuck

INSERT INTO member(e_mail) VALUES('johnwhite@msn.com');

Can anyone help me please....

Similar Threads

How can i add textboxes dynamically in an asp page in ASP
How to Update a Data Table? in ASP.NET
Add or Insert a "Content Table" using MS FrontPage in Site Layout and Usability
using javascript to dynamically add to existing html table in JavaScript / DHTML / AJAX
asp:repeater in a form? in ASP.NET

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 874

Code tags enforcer

Offline

6,659 posts
since Dec 2004

Permalink

Apr 24th, 2005

Re: Add an attribute to existing table

After all I found my lost way trough the darknest and here is my final code

(Toggle Plain Text)

ALTER TABLE member
ADD e_mail CHAR(20);

UPDATE member SET e_mail='johnwhite@msn.com' WHERE member_no='A2345';
UPDATE member SET e_mail='leeJulie@aol.com' WHERE member_no='R3456';
UPDATE member SET e_mail='d_ford@yahoo.com' WHERE member_no='S4567';
UPDATE member SET e_mail='maryhowe@aol.co.uk' WHERE member_no='S7654';
UPDATE member SET e_mail='mrobinson@msn.com' WHERE member_no='A7412';
UPDATE member SET e_mail='ahmed_h@msn.co.uk' WHERE member_no='B6421';
UPDATE member SET e_mail='AnnMat@f2s.com' WHERE member_no='A1246';
UPDATE member SET e_mail='amohammady@box.com' WHERE member_no='R8916';
UPDATE member SET e_mail='fairyjack@aol.com' WHERE member_no='S1248';

Hope I will pass my module :lol:

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 874

Code tags enforcer

Offline

6,659 posts
since Dec 2004

Permalink

Apr 27th, 2005

Re: Ass an attribute to existing table

Dear friend

The only way you can insert data (or in other words update ur table with new data) is by using UPDATE command followed by some condition.

And have u used TOAD( a software for viewing sql data in a neat format unlike SQL* plus).I think that will make ur life a bit easy as well for updating large volumes of data in near future

haria_kishore

Reputation Points: 11

Solved Threads: 1

Light Poster

Offline

28 posts
since Jan 2005

Permalink

Apr 30th, 2005

Re: Ass an attribute to existing table

Thanks for interest.
As you can see this was part of my coursework. I must admit that to learn SQL was interesting experience however the course hasn't got appropriate backup. What I mean, our tutor answers been often confusing, not to much in notes and tutorials did not provide enought experience, for example to insert data in new attribute. Only think close to this for us was update already existing data. In the proces of learning it logicly come to me to do it exactly as populating table with INSERT INTO.
Now I know, I was wrong.

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 874

Code tags enforcer

Offline

6,659 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: creating a MSDE database

Next Thread in Database Design Forum Timeline: Help

DaniWeb Message

Cancel Changes

User Name
Password