and if that won't work you dont have alter privileges for your table.
Cheers,
Nikke
> Från: "Billy Passauer" <[EMAIL PROTECTED]>
> Datum: Thu, 12 Apr 2001 15:16:19 -0400
> Till: "Dean MacIsaac Jr." <[EMAIL PROTECTED]>
> Kopia: <[EMAIL P
Billy, and friends,
Always helpful info: What have you tried, and what errors are you
getting?
alter table web_guests add column (p1 varchar(15), p2 varchar(15));
Error 1064 You have an error in your sql syntax near '(p1 varchar(15), p2
varchar(15))' at line 1
TIA,
Dean MacIsaac
---
Always helpful info: What have you tried, and what errors are you
getting?
Try:
ALTER TABLE yourtablename ADD COLUMN (newcol1 VARCHAR(10), newcol2
VARCHAR(25));
... Billy ...
> -Original Message-
> From: Dean MacIsaac Jr. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 3:0
hi.
alter table sometable add column newcol VARCHAR(20) after oldcol;
change sometable, newcol, oldcol and the column definition to what you want.
hth.
-ravi.
-Original Message-
From: Dean MacIsaac Jr. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 3:04 PM
To: [EMAIL PROTECT
ALTER TABLE tablename ADD COLUMN column_name ;
On 4/12/01 12:04 PM, "Dean MacIsaac Jr." <[EMAIL PROTECTED]> wrote:
> I'm just not understanding what I'm reading in Ch. 7.
>
> I created a table, in my database, now I just want to add 2 more varchar
> columns to it. I tried following along
