"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 in the file. > > I cut and pasted "figurae" from mysqlcc just to make sure I have the right > (Latin) spelling. > > The following placed on the line above in the same file above this INSERT > returns a set of ids. > > SELECT id FROM figurae; > > I am using mysql (the command line tool). > > Can anyone tell me what I am doing wrong? >
Look at INSERT .. SELECT statement: http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]