Matt, alter table table_name add column column_name column_decriptions;
alter table table_name drop column column_name; Try checking documentation for more details: http://www.mysql.com/doc/A/L/ALTER_TABLE.html Hope this helps! > > > Can anyone give me an example of an alter table syntax that. > > 1.) adds a column > 2.) deletes a column. > > I am reading the examples in the oreilly book, and it does not work > ???? also the Oracle or Infomix syntax doesn't work. > > can someone give me a clue please. > > Thanks, > > Matt. > > > --------------------------------------------------------------------- > 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 John Barton [EMAIL PROTECTED] --------------------------------------------------------------------- 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
