Well, I skiped this manual part :-)
Maybe the simple select and insert is the simplest form.
--
Julio Nobrega
Don't eat the yellow snow.
"Jim" <[EMAIL PROTECTED]> wrote in message
news:p05101010b8318afec141@[192.168.1.17]...
>
> It appears that this is forbidden ...
>
> From mysql.com:
It appears that this is forbidden ...
From mysql.com:
The target table of the INSERT statement cannot appear in the FROM
clause of the SELECT part of the query because it's forbidden in ANSI
SQL to SELECT from the same table into which you are inserting. (The
problem is that the SELECT poss
I don't know if it is the best but here's an idea:
INSERT INTO table SELECT ha, he, hi, ho, hu FROM table LIMIT 1;
--
Julio Nobrega
Don't eat the yellow snow.
"Jim" <[EMAIL PROTECTED]> wrote in message
news:p0510100fb8318736de56@[192.168.1.17]...
>
> What's the best way to duplicate a mysq
3 matches
Mail list logo