帮我写一个往表里存入String workflowId, String thirdId, int form_id, String variable, Date createTime,Date updateTime字段的sql
时间: 2024-02-12 13:07:29 浏览: 83
数据库设计文档字段大全
可以尝试使用如下的SQL语句来向表中插入数据:
```sql
INSERT INTO your_table_name (workflowId, thirdId, form_id, variable, createTime, updateTime) VALUES ('value1', 'value2', 123, 'value3', '2021-10-01 10:00:00', '2021-10-01 11:00:00');
```
其中,`your_table_name`是你要插入数据的表名,`workflowId`、`thirdId`、`form_id`、`variable`、`createTime`和`updateTime`分别是表中的字段名。你需要将`value1`、`value2`和`value3`替换为具体的值,例如:
```sql
INSERT INTO your_table_name (workflowId, thirdId, form_id, variable, createTime, updateTime) VALUES ('workflow001', 'third001', 123, '{"key1":"value1","key2":"value2"}', '2021-10-01 10:00:00', '2021-10-01 11:00:00');
```
这个例子中,我们向表中插入了一个`workflowId`为`workflow001`、`thirdId`为`third001`、`form_id`为`123`、`variable`为`{"key1":"value1","key2":"value2"}`、`createTime`为`2021-10-01 10:00:00`、`updateTime`为`2021-10-01 11:00:00`的记录。
阅读全文