We need your help! 🔥
Please consider disabling your ad-blocker to support this website! 🔑
We are a free, community-supported website! 🥰
We only display small unobtrusive ads which help us stay online! 💯
Thank you in advance! ❤️
We are a free, community-supported website! 🥰
We only display small unobtrusive ads which help us stay online! 💯
Thank you in advance! ❤️
SQL Insert Command
A SQL command string to Insert (or Update) data into a SQL table.
Inputs
| Name | ID | Description | Type |
|---|---|---|---|
| Table | Table | A database table. | String |
| Columns | Columns | A list of columns to write data to in a table. | String |
| Data | Data | A list of data to write. | String |
| Update | Update | Default is set to 'False' to use INSERT INTO method. 'True' uses UPDATE SET WHERE method to update columns based on a condition. | Boolean |
| Where | Where | A list of conditions for which rows to update. Conditions should match the list of data to update. | String |
Outputs
| Name | ID | Description | Type |
|---|---|---|---|
| SQL Code | SQL | Mesh SQL Code | String |
Site design © Robin Rodricks.
Site co-created by Andrew Heumann.
Slingshot and associated data © 2024 Nathan Miller.
Rhinoceros and Grasshopper are registered trademarks of Robert McNeel & Associates.
Hosted by GitHub