sietse11 Posted January 22, 2014 Group: Members Topic Count: 44 Topics Per Day: 0.01 Content Count: 127 Reputation: 7 Joined: 02/10/13 Last Seen: February 1, 2019 Share Posted January 22, 2014 Hey folks, I am using an SQL table for mob skills and I just made my 1st typo. Chocked, is the state I'm in. The skill_db does not have a unique key, and thus I can't replace my typo or delete the entry by conventional means. So I tried this UPDATE FROM 'ragnarok'.'mob_skill_db' CONDITION= 'longrangeattacked' WHERE CONDITION='longrangedattacked' I dunno how wrong my quarry is here but it ain't working, and I need it fixed asap. Help would be greatly appreciated Ugh no one has even seen this T_T Quote Link to comment Share on other sites More sharing options...
sandbox Posted February 7, 2014 Group: Members Topic Count: 38 Topics Per Day: 0.01 Content Count: 949 Reputation: 174 Joined: 06/12/12 Last Seen: May 9 Share Posted February 7, 2014 (edited) UPDATE `ragnarok`.`mob_skill_db` SET `CONDITION`='longrangeattacked' WHERE `CONDITION`='longrangedattack' don't forget to backup because i just wrote that code from scratch Edited February 7, 2014 by sandbox Quote Link to comment Share on other sites More sharing options...
Question
sietse11
Hey folks,
I am using an SQL table for mob skills and I just made my 1st typo.
Chocked, is the state I'm in.
The skill_db does not have a unique key, and thus I can't replace my typo or delete the entry by conventional means.
So I tried this
I dunno how wrong my quarry is here but it ain't working, and I need it fixed asap.
Help would be greatly appreciated
Ugh no one has even seen this T_T
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.