In this post, we will see how to resolve Insert value after default value column in prepare-execute
Question:I have a table where i am inserting values using
datecolumn. I need to pass the values for other 3 columns though
I am not sure how to pass the value to
regionafter the default
date(something like below)?
Best Answer:The bind variables are being bound to the
?placeholders. It does not matter where they are in the statement or what is between the bind variables within the statements.
- The first variable is bound to the first
- The second variable is bound to the second
- The third variable is bound to the third
The Perl code does not need to know about the
INSERTstatement, it just needs to know how many
?s (anonymous bind variables) there are in the statement and provide one value for each of them.
If you have better answer, please add a comment about this, thank you!