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
---
2, 2001 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: adding columns to my database
>
>
> 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 wi
PROTECTED]
Subject: adding columns to my database
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 with the manual, but, I'm not seeing
it, and I get errors every time
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
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 with the manual, but, I'm not seeing
it, and I get errors every time in telnet. If someone would be so kind as
to help me, I appr