In the last episode (Dec 09), kayamboo said: > I don't get you. > But when I executed the drop table syntax fromt he command line, the result > was this error > > mysql> alter table town_db drop primary key ; > ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db' > (errno: 150) > mysql>
The alter table failed because of error 150. Run the command "perror 150" at your shell prompt (not the mysql prompt) to find out why the command failed. -- Dan Nelson [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