Inserts rows into a global or central table.
Available in a network database and requires the star$modify role.
Parameters:
| Name | Optional | Type | Description |
| table$ | Mandatory | Text | The table to insert rows into. |
| columns$ | Mandatory | Text | List of columns to be populated. |
| rows$ | Mandatory | Text | Values to be inserted. |
Examples:
SELECT insert_rows('mytable','col1,col2','(1,2)'); -- inserts one row into table mytable
SELECT insert_rows('mytable','col1,col2','(1,2),(3,4)'); -- inserts two rows into table mytable
Tips:
- The star$tables lists existing tables and their scope
Comments
Article is closed for comments.