Insert select

[UtiliseIT]

Hi,

What is the process of inserting some records based on a select statement? I am using PyMySql.

An example or link to tutorial would be greatly appreciated.

Thanks in advance

Todd

[Larz60+]

There is a syntax that allows for an update with a where clause that is a select instance.

[ WITH [ RECURSIVE ] with_query [, ...] ]
UPDATE [ ONLY ] table [ * ] [ [ AS ] alias ]
    SET { column = { expression | DEFAULT } |
          ( column [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]
    [ FROM from_list ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ]
    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

The where clause can contain a query