How to Copy data from one table to another?

philosophology

I need have two tables with exactly the same fields, I want to copy rows from one table to another. How do I do that?

Thanks.

coldwerturkey

$query = "SELECT * FROM table";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
	mysql_query("INSERT INTO anothertable (column) VALUES ('{$row['column']}')");
}

philosophology

coldwerturkey;10910774 wrote:

$query = "SELECT * FROM table";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
	mysql_query("INSERT INTO anothertable (column) VALUES ('{$row['column']}')");
}

What is column? Is it a number? or name of the column?

coldwerturkey

philosophology;10910775 wrote:
What is column? Is it a number? or name of the column?

it's a dummy variable for you to replace with your desired column name(s). If you didn't know that, I suggest you search google for some basic php/mysql tutorials that will explain how to use mysql/php. (btw, I'm assuming you're using mysql and have access to the database via php)

edit:
..disregard what I suggested, I did what you should of done in the first place and searched google and the very first result gave me,

insert
into table2
select *
from table1

so use that, it's a much, much, better approach to accomplish your task.

dagon

i would think this may be a little faster

INSERT new_table SELECT * FROM old_table;

woops-- coldwerturkey posted this before i read all the thread (silly me)

philosophology

coldwerturkey;10910776 wrote:
it's a dummy variable for you to replace with your desired column name(s). If you didn't know that, I suggest you search google for some basic php/mysql tutorials that will explain how to use mysql/php. (btw, I'm assuming you're using mysql and have access to the database via php)

edit:
..disregard what I suggested, I did what you should of done in the first place and searched google and the very first result gave me,
insert
into table2
select *
from table1
so use that, it's a much, much, better approach to accomplish your task.

But I want to specify which rows to be copied, I don't want all of them!

Can I just say:

INSERT INTO TBL2 SELECT * FROM TBL1 WHERE VAR1='something'

Sxooter

Yep, the where clause should work just fine.