Blocks & Flow EditorDatabase
create table
Creates a table in the database.
Creates a table in the database.
Configuration
| Field | Description |
|---|---|
| Display Name | Label on the block. |
| Database | SQLite or MySQL. |
| Host name | MySQL host (hidden for SQLite). |
| Port Number | MySQL port. |
| Username | MySQL username. |
| Password | MySQL password. |
| Database Name | Target database identifier. |
| Table Name | Table to create. |
| Column Name | Column identifier. |
| Data Type | INT, FLOAT, DOUBLE, VARCHAR, BOOLEAN, DATE, DATETIME, TIMESTAMP. |
| Max Length | Max length (default 255). |
| Default Value | Default on insert. |
| Auto Increment | Auto-increment primary key. |
| Primary Key | Mark as primary key. |
| Nullable | Allow NULL. |
| Unique | Enforce uniqueness. |
Outputs
| Port | Description |
|---|---|
| Output 1 | Message passes through after the operation completes |
Notes
- Mandatory column flags can be checked/unchecked per preference.