Grasshopper Docs

Community documentation for Grasshopper add-ons & plugins

RDBMS
SQL
Utility

SQL Insert Command

A SQL command string to Insert (or Update) data into a SQL table.

Inputs

NameIDDescriptionType
TableTableA database table.String
ColumnsColumnsA list of columns to write data to in a table.String
DataDataA list of data to write.String
UpdateUpdateDefault is set to 'False' to use INSERT INTO method. 'True' uses UPDATE SET WHERE method to update columns based on a condition. Boolean
WhereWhereA list of conditions for which rows to update. Conditions should match the list of data to update.String

Outputs

NameIDDescriptionType
SQL CodeSQLMesh SQL CodeString

Site design © Robin Rodricks.   Co-created by Andrew Heumann.   Slingshot and associated data © 2020 Nathan Miller.  
Rhinoceros and Grasshopper are registered trademarks of Robert McNeel & Associates.  Hosted by GitHub

Report an Issue  |  Terms of Service