Help wanted to synchronize two table

[scriptinn.com]

Hi,
I want to synchronize passwords of idx_link_temp with idx_link tables so that the current passwords in idx_link_temp should be replaced with the passwords in idx_link table. Being a Windows and MS SQL user, i could not format a correct query to run for this job.
Can someone please help me?

thanks in advance.

[esm]

Being a Windows and MS SQL user, i could not format a correct query to run for this job.

SQL is SQL and while there are some differences between the various SQL's, I doubt there are any differences at the level you would be working at. Read a record, find that record in the other table and update the record in the other table.

I want to synchronize passwords of idx_link_temp with idx_link tables so that the current passwords in idx_link_temp should be replaced with the passwords in idx_link table

For the life of me I cannot imagine why you would want to "synchronize passwords of idx_link_temp with idx_link tables.

The idx_link_temp table is used to store the record information created during the ADD link process. When the admin validates the added listing, the information is transferred from the record in idx_link_temp table to a new record in the idx_link table and the record in the idx_link_temp table is deleted.

The idx_link_temp table should always be empty unless a new listing is waiting to be approved.

Well, that is the way it worked in v3.x.



.

[scriptinn.com]

SQL is SQL and while there are some differences between the various SQL's, I doubt there are any differences at the level you would be working at. Read a record, find that record in the other table and update the record in the other table.

I was meant to say Microsoft SQL Server, which allows us to execute various sub-queries in a single run, however MySQL does not support this, as of my knowledge.

So, if it was Microsoft SQL Server, i could have execute this query...

UPDATE idx_link, idx_link_temp SET idx_link_temp.password = idx_link.password where idx_link.link_id = idx_link_temp.link_id

For the life of me I cannot imagine why you would want to "synchronize passwords of idx_link_temp with idx_link tables.

You're right that it does not make a sense, but i've done some modifications to run my directory in my personal ways due to which i have different passwords in both tables

Do you have a solution?

[esm]

You're right that it does not make a sense, but i've done some modifications to run my directory in my personal ways due to which i have different passwords in both tables

No problem. the temp table is designed to be transitory. Among other things, INDEXU will try to delete the record when you validate it and if you modify the record (and require permission is set), the record in the temp table will be overwritten.

as for your solution, your above UPDATE command will work properly in mySQL.



.

[persut]

i am not realy sure where you are going with this, but here a link i use to reference some simple mysql statements.


http://www.w3schools.com/sql/sql_update.asp