List:General Discussion« Previous MessageNext Message »
From:kayamboo Date:December 9 2002 12:17am
Subject:Re: alter table syntax
View as plain text  
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>

Can you make me clear?


regards



----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "kayamboo" <kayamboosuresh@stripped>
Cc: "list mysql" <mysql@stripped>; "R. Hannes Niedner"
<hannes.niedner@stripped>
Sent: Saturday, December 07, 2002 2:19 AM
Subject: Re: alter table syntax


> In the last episode (Dec 06), kayamboo said:
> > When I tried to drop the key, this was the error
> >
> > mysql> alter table town_db drop primary key ;
> > ERROR 1025: Error on rename of '.\forest\#sql-f6_1' to
'.\forest\town_db' (errno: 150)
>
> And what does "perror 150" return (it's a shell command, not an SQL
> one)?
>
> --
> Dan Nelson
> dnelson@stripped
>
> ---------------------------------------------------------------------
> 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 <mysql-thread126832@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-kayamboosuresh=softhome.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
alter table syntaxkayamboo6 Dec
  • Re: alter table syntaxR. Hannes Niedner6 Dec
    • Re: alter table syntaxkayamboo6 Dec
      • re: Re: alter table syntaxEgor Egorov6 Dec
      • Re: alter table syntaxDan Nelson6 Dec
    • Re: alter table syntaxkayamboo9 Dec
      • Re: alter table syntaxDan Nelson9 Dec
    • Re: Re: alter table syntaxkayamboo9 Dec
    • Re: alter table syntaxListen Hinz9 Dec