update spawn

zfoxfire · May 26th 2016

I'm running mysql on a Debian 8 server. I can't seem to set spawn point. i keep getting syntax error. I know I can do this via game console but I do not have access to my gaming computer so I'm doing this backend

mysql> update WorldInfos set Value="-4011.0 67.0 506.0" where Key="Spawnposition";

I keep getting a syntax error

red51 · May 26th 2016

It's important to use backticks for "Value" and "Key", e.g.:
update WorldInfos set `Value`="-4011.0 67.0 506.0" where `Key`="Spawnposition";

zfoxfire · May 26th 2016

The drawback to not choosing to be a DBA in life is that I suck at the occasional sql queries I need to run.

Thanks Red. it worked

Participate now!