inserts data into a table in an SQL connection.
Details and Options
- To use SQLInsert, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following options can be given:
"ColumnSymbols" None symbols to be associated with results "EscapeProcessing" True translate escaped JDBC function syntax "FetchSize" Automatic JDBC driver hint for filling result sets "GetAsStrings" False return all results as strings "GetGeneratedKeys" False return keys associated with updated records "MaxFieldSize" Automatic byte limit for variable-length column types "MaxRows" Automatic the maximum number of rows to return "ShowColumnHeadings" False whether to return headings with the results "Timeout" $SQLTimeout the timeout for the query "BatchSize" 1000 process inserts in batches of this many records "JavaBatching" True perform parameter batching in Java layer instead of Wolfram Language layer
Examplesopen allclose all
Basic Examples (1)
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.
Working with Dates and Times (1)
Selected date and time data will return with head SQLDateTime:
Possible Issues (1)
A DateObject entered without a setting for the TimeZone option will use the default $TimeZone. Note that a numeric value for the time zone will not adjust for daylight saving that might apply to the date.
To avoid this problem, use a named zone ID or $TimeZoneEntity.