> 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
Those statments will surely cause errors, since you've not spelled TABLE or PRIMARY correctly. Are these your actually working statements, or just typos. Please use cut/paste if you are giving code to someone to check for you. -- Amer Neely [EMAIL PROTECTED] Softouch Information Services: www.softouch.on.ca/ Perl / PHP / MySQL / CGI programming for shopping carts, data entry forms. "We make web sites work!" --------------------------------------------------------------------- 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
