Mysql Move a record? (Mysql/pawn Question)
#4

Quote:
Originally Posted by DarrenReeder
View Post
No, imagine ive got two tables..

Code:
//accounts table with these attributes...

ID
Username
Password
Level
Kills
Deaths


//Now another table called, Accounts2 with attributes.

ID
Username
Password
LEvel
Kills
Deaths
If i have a record in the first table.. i want to remove it from that first table.. and place it into the new table..
I don't see why you ever want to do that, but anyways;
Load a row from the 1st tabel, save it all into a variable, then remove it, then save it into the 2nd tabel.
Reply


Messages In This Thread
Mysql Move a record? (Mysql/pawn Question) - by DarrenReeder - 05.11.2010, 17:23
Re: Mysql Move a record? (Mysql/pawn Question) - by playbox12 - 05.11.2010, 18:18
Re: Mysql Move a record? (Mysql/pawn Question) - by DarrenReeder - 05.11.2010, 18:47
Re: Mysql Move a record? (Mysql/pawn Question) - by DVDK - 05.11.2010, 19:22
Re: Mysql Move a record? (Mysql/pawn Question) - by DarrenReeder - 05.11.2010, 19:23

Forum Jump:


Users browsing this thread: 1 Guest(s)