Menu

#11 MySQL table "char" causes problems

open
nobody
None
5
2005-01-27
2005-01-27
No

One of the tables in the web side of things is called
"char", which is a MySQL reserved keyword. While it
works, it makes it tricky to do manual selects against
the table in the mysql client (need to use wow.char),
and mysqldump spits the dummy and dies.

Can this table please be renamed to something else?

Discussion

  • Jason Lee

    Jason Lee - 2005-01-27

    Logged In: YES
    user_id=1038448

    Well I use php-nuke therefore my table is named nuke_wow_char

    But I understand where this could cause a problem, soo maybe
    "player" would be a good rename.

     
  • Trevor Phillips

    Trevor Phillips - 2005-01-27

    Logged In: YES
    user_id=575134

    How about just "character"? Since character is more apt
    (since a single Player can have several Characters...)

     
  • Jason Lee

    Jason Lee - 2005-01-27

    Logged In: YES
    user_id=1038448

    That is true, but character seems to be a long string, soo
    what about "toon".

     

Log in to post a comment.