Re: PHP & MySQL "Move"
| From: | John Taylor-Johnston | Date: | Tue, 04 Mar 2003 07:31:04 +0000 |
| Subject: | Re: PHP & MySQL "Move" | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138046@lists.php.net to get a copy of this message | ||
Found this for anyone interested.
http://www.mysql.com/doc/en/INSERT_SELECT.html
John Taylor-Johnston wrote:
> I was wondering about this, but decided to ask first first:
>
> INSERT INTO ccl.ccl_main VALUES (select * from greid.ccl where id=28);
> delete * from greid.ccl where id=28;
>
> Both tables would have to have the same structure ?
--
John Taylor-Johnston
-----------------------------------------------------------------------------
"If it's not open-source, it's Murphy's Law."
' ' ' Collège de Sherbrooke:
ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/
- Université de Sherbrooke:
http://compcanlit.ca/
819-569-2064