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:
http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
I'm not asking for an alternative way to do it; I'm asking what
is wrong with what I did?
I did rework it to an alternative syntax, but I wanted to
use the SET syntax so I could list all my old fields right
next to my new fields, so that I didn't have to
skip up and down 40 lines to see how I have them matched up.
So does INSERT ... SET ... work? How?
-Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]