dump data from one table to another

[abdfahim]

Hi,

 

I have 2 tables t1 and t2. They have identical columns only except t1 has one extra column x1. What I want is to dump data from t2 to t1, and in the x1 column, put the person's name (get from SESSION).

 

So, I want the best optimized way to do something like

 

mysql_query("INSERT INTO `t1` '".$usename."' , SELECT * FROM `shareltp`"); //which obviously doesn't work

 

Plz help

[BlueSkyIS]

specify columns

 

$sql = "INSERT INTO t1 (col1, col2, col3, col4, col5) SELECT col1, col2, col3, col4, col5 FROM t2";
mysql_query($sql) or die(mysql_error() . " IN $sql");

[abdfahim]

well, my problem is the extra column in t1 table (say col0). How to incorporate that?

[ManiacDan]

well, my problem is the extra column in t1 table (say col0). How to incorporate that?

Are you asking how you take 7 columns and insert them into a 6 column table?  You can't.

 

If you're asking how to ignore a specific column, read the previous reply more carefully.

 

-Dan

[abdfahim]

well, my problem is the extra column in t1 table (say col0). How to incorporate that?

Are you asking how you take 7 columns and insert them into a 6 column table?  You can't.

 

If you're asking how to ignore a specific column, read the previous reply more carefully.

 

-Dan

 

I haven't ask either of them .. I want to take 6 column from a table and insert them in a 7 column table whereas filling up the 7th column with a constant (don't say to use default coz that constant will vary with the user)

[ManiacDan]

INSERT INTO t1 (col1, col2, col3, col4, col5, col6, col7) SELECT *, SomeFunction(t2.someColumn, 'Make The Data Here') FROM t2

-Dan

[litebearer]

you may need to

1. copy the six columns.

2. do an immediate update for that record to add the new column data

[ManiacDan]

If you can't calculate the last column's value on the fly (like in my query) then just pull all the data into a scripting language and make one huge insert out of it.  You haven't said how many rows or how you're going to get this mystery column's value.

[abdfahim]

You haven't said how many rows or how you're going to get this mystery column's value.

 

it'll be the date string read from a text file at the moment of insert