Help me with this

Results 1 to 1 of 1
  1. #1
    Newbie kerelangelo is offline
    MemberRank
    May 2009 Join Date
    1Posts

    Help me with this

    when im trying to change my user id and password in My SQL Query Editor and when a apply changes its
    says

    ALTER TABLE `ragnarok`.`login` MODIFY COLUMN `userid` ragnarok CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
    MODIFY COLUMN `user_pass` ragnarok CHARACTER SET latin1 COLLATE latin1_bin NOT NULL;


    Eror when executing

    ALTER TABLE 'ragnarok'.'login' MODIFY COLUMN ' userid' ragnarok CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,

    MySQL error number 1064
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ragnarok CHARACTER SET latin1' COLLATE latin1_bin NOT NULL, MODIFY COLUMN ' user' at line1


    help me with this... nid ur reply asap




Advertisement