"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]