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 tab
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 ?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: h
2 matches
Mail list logo