|
|
Posted by Colin McKinnon on 10/08/05 11:16
Angelos wrote:
> First of all sorry if this is not the correct newsgroup for this question,
> but I am using PHP with MYSQL and someone here could have an answer and
> the experience.
>
This is the wrong newsgroup.
> REPLACE INTO content SELECT bak_content_id, bak_content_title FROM
> content_bak WHERE backup_id = '".$_GET['buckup_id']."'";
>
<snip>
> What I want to do is to REPLACE the TABLE CONTENT content_id = $x with
> the TABLE CONTENT backup_id = $y AND bak_content_id =$x
>
REPLACE INTO content (id, title)
SELECT bak_content_id, bak_content_title
FROM content_bak
WHERE backup_id={$_GET['backup_id']}
You might find a good book on SQL & MySQL in particular of benefit.
C.
Navigation:
[Reply to this message]
|