how do i shift

Anon

I have a table in which I have some subscribers and now what I wnat is to shift the records of this table to another table..

Naveen

saltwater

you might be able to do this in one query but i doubt it, I am not THAT good with MySQL

$query=mysql_query("SELECT field1,field2 FROM table1 WHERE <condition>",$link_id);
for ($i=0,$i<mysql_num_rows($query);$i++) {
$field1=mysql_result($query,$i,0);
$field2=mysql_result($query,$i,1);
mysql_query("INSERT INTO table2 SET field1='$field1',field2='$field2',...",$link_id);
}

Anon

Psuedo code (ish):

$Sresult = mysql("SELECT * FROM old_table");
while ($old_data = mysql_fetch_row($Sresult)); {
$Iresult = mysql_query("INSERT INTO new_table VALUES('$old_data[0]',$old_data[1], . . ");

}

Essentially you trundle through one table and add records into the other.

Don't forget to add error checking if you need it.

If you want to do this just once (or irregularly) use phpmyadmin dump and 'reload into the new table. You will need to edit the dump file to substitute the new table name into the insert strings.

Cheers,

Cris

Anon

If you are using MySQL i would use something like this.

INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE
tblTemp1.fldOrder_ID > 100;

you should be able to see more examples a www.mysql.com, this just show one field.

Chris

smarlowe

Please tell us which dbms you're using in the future, because a lot of this is slightly different from one to another.

In postgresql you can do this one of several ways.

from a command prompt:

pg_dump dbname -t tablename >somefile
vi somefile
(change the table name to the new table name here)
psql dbname -e <somefile

Is the "around the back way" and allows you to port your table to different databases on different machines easily.

If the table doesnt' exist this works fine. If it does, then edit somefile so that the table deletion/creation parts are gone and only the connect and copy from stdin are still there.

In SQL you can do it one of two ways. If the destination table does NOT exist, then:

select * into newtable from oldtable [optional where clause here.]

if the table exists, you must be more explicit:

insert dest (column1, column2, ... columnn) (select column1, column2, ... columnn from source);