Garth Webb wrote:
I'm not asking for an alternative way to do it; I'm asking what
is wrong with what I did?
It looks like you want to copy over several or all values from a second
table. The INSERT .. SELECT syntax isn't an alternate way, its the only
way.
Okay, thanks for the clarification. I di
On Mon, 2004-05-17 at 13:37, P. Hill wrote:
> Victoria Reznichenko wrote:
> > "P. Hill" <[EMAIL PROTECTED]> wrote:
> >
> >>Why when there is a figurae, figurae2 table does the follow give an error?
> >>INSERT INTO figurae2 SET id = figurae.id;
> >>
> >>The error is:
> >>ERROR 1109 at line 35: Unkn
Victoria Reznichenko wrote:
"P. Hill" <[EMAIL PROTECTED]> wrote:
Why when there is a figurae, figurae2 table does the follow give an error?
INSERT INTO figurae2 SET id = figurae.id;
The error is:
ERROR 1109 at line 35: Unknown table 'figurae' in field list
>
Look at INSERT .. SELECT statement:
"P. Hill" <[EMAIL PROTECTED]> wrote:
> Why when there is a figurae, figurae2 table does the follow give an error?
> INSERT INTO figurae2 SET id = figurae.id;
>
> The error is:
> ERROR 1109 at line 35: Unknown table 'figurae' in field list
>
> Line 35 is the Insert line shown. There are no follow
