PHP & MySQL "Move"
| From: | John Taylor-Johnston | Date: | Fri, 28 Feb 2003 23:08:51 +0000 |
| Subject: | PHP & MySQL "Move" | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137646@lists.php.net to get a copy of this message | ||
Assuming MySQL can do this, I need to generate some code that would MOVE a record from one table to
another. Not just a MySQL code problem?
Pseudo code: base.table
select base1.table where id=25
insert result base2.table
delete base1.table where id=25
Can I even do this in MySQL? If so, what will the PHP code look like?
I would have to dump the select into memory?
Sorry if I end up off topic.