Insert and Update Statements
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The MySQL driver supports returning parameter metadata for the following forms of Insert and Update statements:
-
INSERT INTO foo VALUES (?, ?, ?) -
INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?) -
UPDATE foo SET col1=?, col2=?, col3=? WHERE col1operator? [{AND | OR}col2operator?]
where operator is any of the following SQL operators: =, <, >, <=, >=, and <>.