Gossamer Forum: General: Databases and SQL: UPDATE TABLE (trcandy)

Gossamer Threads

Home : General : Databases and SQL :

UPDATE TABLE

Oct 9, 2002, 5:14 AM

trcandy

New User (4 posts)

Oct 9, 2002, 5:14 AM

Shortcut

UPDATE TABLE

Hi there,

I am hoping that what I would like to do is easy!

I have a table (product) and two fields (item and altitem)

I want to update everything in altitem with what is in item, ie. ITEM has 2293, I would like ALTITEM = 2293

Any help would be great

I have little clues on how to do this as I thought a variable would be needed to ensure that I am updating the correct record.

Thanks

Todd

Subject	Author	Views	Date
UPDATE TABLE	trcandy	12484	Oct 9, 2002, 5:14 AM

Re: [trcandy] UPDATE TABLE	Andy	12194	Oct 9, 2002, 7:34 AM

Re: [trcandy] UPDATE TABLE	Paul	12250	Oct 9, 2002, 7:40 AM

Re: [Paul] UPDATE TABLE	trcandy	12257	Oct 9, 2002, 7:54 AM

Re: [trcandy] UPDATE TABLE	Paul	12273	Oct 9, 2002, 8:01 AM

Re: [Paul] UPDATE TABLE	trcandy	12329	Oct 9, 2002, 8:03 AM

Re: [trcandy] UPDATE TABLE	Paul	12232	Oct 9, 2002, 8:05 AM

Re: [Paul] UPDATE TABLE	SeanP	12274	Oct 9, 2002, 5:34 PM

Re: [SeanP] UPDATE TABLE	Paul	12205	Oct 10, 2002, 2:44 AM

Re: [Paul] UPDATE TABLE	SeanP	12118	Oct 10, 2002, 6:35 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676