Blocks & Flow EditorDatabase

create table

Creates a table in the database.

Creates a table in the database.

Bot Studio create table block configuration

Configuration

FieldDescription
Display NameLabel on the block.
DatabaseSQLite or MySQL.
Host nameMySQL host (hidden for SQLite).
Port NumberMySQL port.
UsernameMySQL username.
PasswordMySQL password.
Database NameTarget database identifier.
Table NameTable to create.
Column NameColumn identifier.
Data TypeINT, FLOAT, DOUBLE, VARCHAR, BOOLEAN, DATE, DATETIME, TIMESTAMP.
Max LengthMax length (default 255).
Default ValueDefault on insert.
Auto IncrementAuto-increment primary key.
Primary KeyMark as primary key.
NullableAllow NULL.
UniqueEnforce uniqueness.

Outputs

PortDescription
Output 1Message passes through after the operation completes

Notes

  • Mandatory column flags can be checked/unchecked per preference.
On this page

On this page