Query Sql (Copy a Table)

[Zell]

Why this command don't work?
 

query_sql "INSERT INTO char_store (`char_id`,`account_id`,`char_num`,`name`,`class`,`base_level`,`job_level`,`base_exp`,`job_exp`,`zeny`,`str`,`agi`,`vit`,`int`,`dex`,`luk`,`max_hp`,`hp`,`max_sp`,`sp`,`status_point`,`skill_point`,`option`,`karma`,`manner`,`party_id`,`guild_id`,`pet_id`,`homun_id`,`elemental_id`,`hair`,`hair_color`,`clothes_color`,`weapon`,`shield`,`head_top`,`head_mid`,`head_bottom`,`robe`,`last_map`,`last_x`,`last_y`,`save_map`,`save_x`,`save_y`,`partner_id`,`online`,`father`,`mother`,`child`,`fame`,`rename`,`delete_date`,`moves`,`unban_time`) SELECT char_id,account_id,char_num,name,class,base_level,job_level,base_exp,job_ex,zeny,str,agi,vit,int,dex,luk,max_hp,hp,max_sp,sp,status_point,skill_point,option,karma,manner,party_id,guild_id,pet_id,homun_id,elemental_id,hair,hair_color,clothes_color,weapon,shield,head_top,head_mid,head_bottom,robe,last_map,last_x,last_y,save_map,save_x,save_y,partner_id,online,father,mother,child,fame,rename,delete_date,moves,unban_time FROM char WHERE `char_id`='"+getcharid(0)+"'";

I want copy all values of a player from table char to another called char_store, buts it's not working, so how can I?

Never mind, I already figure out

Edited April 12, 2014 by Zell

[Capuche]

You should have the same number of column in the 2 tables

insert into `charlog` select * from `char` where `char_id` = 150000

EDIT : you already solved it, forget it^^

[Emistry]

i think you can try use this too

http://www.w3schools.com/sql/sql_select_into.asp