ALTER TABLE member ADD member_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMERY KEY; ALTER TABEL president DROP suffix
Simon Note:From MySQL by Paul DuBois -----Original Message----- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 14:26 To: [EMAIL PROTECTED] Subject: alter table example. 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
