mysql修改严格语法_大家帮忙看看这个 MySQL 语法错误! 如何修改...

最新推荐文章于 2022-08-22 17:08:33 发布

weixin_39636102

最新推荐文章于 2022-08-22 17:08:33 发布

阅读量134

点赞数

文章标签： mysql修改严格语法

本文链接：https://blog.csdn.net/weixin_39636102/article/details/113442728

版权

net.sf.odinms.client.MapleCharactersaveToDB[charsave]Errorsavingcharacterdatacom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:YouhaveanerrorinyourSQLsyntax;check...

net.sf.odinms.client.MapleCharacter saveToDB

[charsave] Error saving character data com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'WHERE id = 1' at line 1

character 数据无法保存

if (update) {

ps = con.prepareStatement("UPDATE characters SET level = ?, fame = ?, str = ?, dex = ?, luk = ?, `int` = ?, exp = ?, hp = ?, mp = ?, maxhp = ?, maxmp = ?, sp = ?, ap = ?, gm = ?, skincolor = ?, gender = ?, job = ?, hair = ?, face = ?, map = ?, meso = ?, hpApUsed = ?, mpApUsed = ?, spawnpoint = ?, party = ?, buddyCapacity = ?, messengerid = ?, messengerposition = ?, rebirths = ?, WHERE id = ?");

} else {

ps = con.prepareStatement("INSERT INTO characters (level, fame, str, dex, luk, `int`, exp, hp, mp, maxhp, maxmp, sp, ap, gm, skincolor, gender, job, hair, face, map, meso, hpApUsed, mpApUsed, spawnpoint, party, buddyCapacity, messengerid, messengerposition, rebirths, accountid, name, world) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

}

这个查询到底如何写才不会语法错误呢?

'WHERE id = 1' 这句到底是什么问题...

MySQL 版本 5.0.67

展开