add_column
Add a new column to a MySQL table by specifying the column name, data type, and optional attributes such as length, nullability, and default value.
Instructions
Add a new column to existing table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
field | Yes | ||
table | Yes |
Input Schema (JSON Schema)
{
"properties": {
"field": {
"properties": {
"default": {
"description": "Default value for the column (as string).",
"optional": true,
"type": "string"
},
"length": {
"optional": true,
"type": "number"
},
"name": {
"type": "string"
},
"nullable": {
"optional": true,
"type": "boolean"
},
"type": {
"type": "string"
}
},
"required": [
"name",
"type"
],
"type": "object"
},
"table": {
"type": "string"
}
},
"required": [
"table",
"field"
],
"type": "object"
}