SQL table resetter script

[K e o u g h]

Hello, as the title says, how can i truncate a table like picklog in script command? like query_sql? 

 

its like making a menu in NPC like:

 

"Reset Picklog"

"Reset Zenylog"

 

if click the picklog the whole picklog table will reset or truncate.

 

anyone can help me please? thank you in advance!

 

[Capuche]

prontera,150,150,5 script jopijip 75,{

setarray .@table$, "zenylog", "picklog";

.@s = select( "truncate zenylog", "truncate picklog" ) -1;

query_logsql "truncate table `"+ .@table$[.@s] +"`";

mes "you truncate table "+ .@table$[.@s];

close;

}

[K e o u g h]

@capuche

 

THANK YOU VERY MUCH!

[Erba]

how about deleting 1 column only?

[nanakiwurtz]

alter table drop column x;

[Capuche]

alter table drop column x;

I think he wants to delete the value in 1 column lol

Use update sql command and set the default value (google please)

[Erba]

hihi sorry sir|!