Transferring data from one table to another? *EDITED*

[Far Cry]

Hey there, I was wondering if this is possible with mysql, my goal is to transfer the users id from the users table to the id field in my status table, thanks in advance. NOTE: Not manually, through a script.

[litebearer]

Yes it is possible, have you tried? what are the structures of the two tables?

[Far Cry]

Yes it is possible, have you tried? what are the structures of the two tables?

users table

 

id

first_name

last_name

gender

username

email

password

avatar

bio

month

day

year

invitational

last_login

active

code

locked

date

ip

online

 

Status table

 

 

id bigint(20)

username

status

status_date

[rwwd]

Usually the order of doing this is:-

 

SELECT FROM table1<--On success of this instruction Proceed to the next

INSERT INTO table2<-- On success of this instruction, optionally do the next, but it is good house keeping...

DELETE FROM table1<--On completion of the above, you can display a nice little message to screen

 

This is kinda a pseudo way of doing a MOVE as there isn't a specific 'MOVE' command that I have found.

 

Hope that makes sense.

 

Rw

[jcbones]

You want to transfer all of the users Id's

$sql = "INSERT INTO Status(id) SELECT id FROM users";

[chintansshah]

still you have an error?