[Query] to edit job type and job level for beginners!

[bestprem]

/*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/ /*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/
use SRO_VT_SHARD /*### Query by Kiro ###*/
declare [MENTION=768752]job[/MENTION]type int ;declare [MENTION=768752]job[/MENTION]lvl int ; declare [MENTION=551894]Char[/MENTION]name varchar(128) 
set [MENTION=768752]job[/MENTION]lvl = '10' -- Job level 
set [MENTION=768752]job[/MENTION]type = '1' -- (1 = Hunter) (2 = Thief) (3 = Hunter) 
set [MENTION=551894]Char[/MENTION]name = 'Kiro' -- Character Name ! 
update _CharTrijob set [Level] = [MENTION=768752]job[/MENTION]lvl , [JobType] = [MENTION=768752]job[/MENTION]type where CharID = (select _char.CharID from _Char where CharName16 = [MENTION=551894]Char[/MENTION]name) /*### Query by Kiro ###*/
/*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/ /*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/ 

[MentaL]