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 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 in telnet. If someone would be so kind as
to help me, I appreciate it.
Sincerely,
Dean MacIsaac
Webmaster
www.starabilias.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
