Re: SQL STATEMENT

by "The Web Center" <admin(at)webctr.com>

 Date:  Sun, 24 Sep 2000 13:34:04 -0400
 To:  <hwg-servers(at)hwg.org>
 Cc:  "Billy O'Connor" <billy(at)kennet1.freeserve.co.uk>
 References:  webplus freeserve
  todo: View Thread, Original
ALTER TABLE tablename ADD columnname DATATYPE modifiers

Darrell

----- Original Message -----
From: "Billy O'Connor" <billy(at)kennet1.freeserve.co.uk>

Hi All,

I wonder if anyone could tell me the SQL Statement I need to add a new
column to an exisiting table... ?

I've read through my MSQL/MySQL book and can't find it anywhere, only the
statement to ALTER Column Datatypes...

I presume/hope I can do this without trashing the complete table and
starting
from scratch !

TIA,

Bill.
(MySQL & SQL Newbie :-) )

HWG: hwg-servers mailing list archives, maintained by Webmasters @ IWA