sietse11 Posted January 22, 2014 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
sandbox Posted February 7, 2014 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
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
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.