Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

by chacham (Prior)
on Aug 26, 2015 at 14:33 UTC ( #1140041=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1140041]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2019-07-24 02:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If you were the first to set foot on the Moon, what would be your epigram?






    Results (32 votes). Check out past polls.

    Notices?