Request Script update 'lastmap' and 'savemap'

[Azeroth]

Hi, i would like to ask. how do i make an SQL script that can update their `lastmap`cor and `savemap`cor to all characters in the server and i want to change it to my custom map name.Since i checked my database and i found out at that they are still save at my old map or previous map.
 

example:

Quote

UPDATE `.`char` SET `last_x`='156', `last_y`='186', `save_map`='mycustomtown', `save_x`='156', `save_y`='186' WHERE  `char_id`=ALL CHARACTERS; --> i don't know how to do this.

Can somebody correct this one? thank you

Edited December 3, 2016 by Azeroth

[Emistry]

UPDATE `char` SET `last_x`='156', `last_y`='186', `save_map`='mycustomtown', `save_x`='156', `save_y`='186'

 

[Azeroth]

17 minutes ago, Emistry said:

UPDATE `char` SET `last_x`='156', `last_y`='186', `save_map`='mycustomtown', `save_x`='156', `save_y`='186'

 

Thanks Emistry i'll check this out.