-
From: Ulrik Witschass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table
Hi, I'm new to this list, hopefully, I can
contribute some wisdom :)
At the moment, I have to update a large database to
be multi
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be multi-company-ready,
so I basically have to add a Column Company_ID to nearly each table.
What would be the easiest way to do this?
I already thought about running a
]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be
multi-company-ready,
so I basically have to add a Column
Run the following for each table:
ALTER TABLE tableName ADD COLUMN Company_ID INT UNSIGNED NULL;
Hope this helps.
Ulrik Witschass wrote:
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be multi-company-ready,
so I
the pdf version.
I hope I have been of help. - Steve G.
-Original Message-
From: Ulrik Witschass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table
Hi, I'm new to this list, hopefully, I can contribute some
At 02:32 PM 3/26/2002, you wrote:
Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
At the moment, I have to update a large database to be multi-company-ready,
so I basically have to add a Column Company_ID to nearly each table.
What would be the easiest way to do this?
I