Welcome to WebmasterWorld Guest from 54.145.235.72

Forum Moderators: open

Transfer Copy Row to Another Table

   
5:06 am on Aug 16, 2012 (gmt 0)

5+ Year Member Top Contributors Of The Month



I have a database with many columns that I would like to copy whole rows from to insert into a second table.

The structures between the two tables are the exact same.

I'd like to avoid having to specify every column name and column value.

I've adapted this code from other forum posts, but I can't get it to work for me. Am I doing something wrong?

$mysql_connect = mysql_connect(...);
mysql_select_db(...);
mysql_set_charset(...);

mysql_query("INSERT INTO table2 (SELECT * FROM table1 WHERE name = '".$name."' LIMIT 1)");

mysql_close($mysql_connect);
7:21 am on Aug 16, 2012 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member




maybe something like

INSERT INTO table2(*) SELECT * FROM table1 WHERE name = '".$name."' LIMIT 1

--- i've not done it.

Alternatively, if there are lots of column names why don't you get them in a query, somethign like:

SELECT column_name FROM information_schema.columns WHERE table_name = tablename
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month