in reply to Interpolating subroutine call in SQL INSERT INTO SELECT statement

"INSERT INTO TABLE2 (COLUMN1, COLUMN2, ". my_subrt(COLUMN3) .") \n".

In SQL, the column list only supports columns, nothing else. The column list is simply a complete or partial list of columns in the table, in arbitrary order.

Function can only affect data, in which case it would be in the select clause, which definitely supports functions.

  • Comment on Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

In Section Seekers of Perl Wisdom