Print Page - ptting values from another table

Title: ptting values from another table
Post by: Cool on Nov 13, 2016, 01:02 PM

Hi how i can put these values from another table

                    query = QuerySQL( sqliteDB, "INSERT INTO Banned( ban_nick, ban_ip, ban_time, ban_expire, ban_expireratio, ban_admin, ban_reason, ban_uid, ban_uid2 ) VALUES ( '"+ player.Name.tostring() +"','"+ player.IP.tostring() +"','"+ time().tostring() +"', '"+ ban_Expires.tostring() +"', '" + expire.tostring() + "', '"+ admin.Name.tostring() +"', '"+ reason.tostring() +"', '"+ player.UID.tostring() +"', '"+ player.UID2.tostring() +"')");

Title: Re: ptting values from another table
Post by: . on Nov 13, 2016, 01:17 PM

3 seconds with Google:

Code Select

insert into table2 (name, address) select name, address from table1
http://stackoverflow.com/questions/1559789/how-to-copy-data-between-two-tables-in-sqlite

Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Cool on Nov 13, 2016, 01:02 PM