Re: adding columns to my database

2001-04-12 Thread N!kke
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

RE: adding columns to my database

2001-04-12 Thread Dean MacIsaac Jr.
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 ---

RE: adding columns to my database

2001-04-12 Thread Billy Passauer
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

RE: adding columns to my database

2001-04-12 Thread Ravi Raman
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

Re: adding columns to my database

2001-04-12 Thread Lindsay Adams
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

adding columns to my database

2001-04-12 Thread Dean MacIsaac Jr.
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