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 following lines in the file.
I cut and pasted figurae from
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 following lines
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:
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: Unknown table 'figurae' in
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