Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2003
    Posts
    6

    Unanswered: Error Altering Table

    When I run the following command:
    ALTER staff ADD status char(1)

    mySQL returns the following error:

    Error on rename of '.\Common\staff.MYI' to '.\Common\#sql2-6a-2fc3.MYI' (Errcode: 13)

    What is the problem?

    Thankyou.

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Error Altering Table

    Originally posted by dbman007
    When I run the following command:
    ALTER staff ADD status char(1)

    mySQL returns the following error:

    Error on rename of '.\Common\staff.MYI' to '.\Common\#sql2-6a-2fc3.MYI' (Errcode: 13)

    What is the problem?

    Thankyou.
    Problem is between chair and monitor :-)))
    Now seriously. Problem is in the syntax of command.
    The right command is following:
    alter table staff add column status char(1);

    More at url: http://www.mysql.com/doc/en/ALTER_TABLE.html

  3. #3
    Join Date
    Jan 2003
    Posts
    6

    Re: Error Altering Table

    Originally posted by ika
    Problem is between chair and monitor :-)))
    Now seriously. Problem is in the syntax of command.
    The right command is following:
    alter table staff add column status char(1);

    More at url: http://www.mysql.com/doc/en/ALTER_TABLE.html
    I tried it exactly as above and till gives me the same error.

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Error Altering Table

    Originally posted by dbman007
    I tried it exactly as above and till gives me the same error.
    Hmmm... this seems to be a bug in the MySQL product.

    OK
    1.What version you are running?
    2. What Operating system you are runnig?

  5. #5
    Join Date
    Jan 2003
    Posts
    6
    OS = Windows 2000
    mySQL = 3.23.47-nt

  6. #6
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by dbman007
    OS = Windows 2000
    mySQL = 3.23.47-nt
    Solution:
    http://www.mysql.com/doc/en/ALTER_TABLE_problems.html

  7. #7
    Join Date
    Jan 2003
    Posts
    6
    I read the man page but can not find any a- or b- files. I did notice that my error code was different from the example on the man page.

    Mine is error: 13 and the example is error: 17. Were can I find the meaning of these codes?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •