Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.w22.dev/llms.txt

Use this file to discover all available pages before exploring further.

MySQL UI lets you create a new table through a visual dialog — no SQL required. You define the table name and each of its columns using form fields, and MySQL UI generates and runs the CREATE TABLE statement for you.
You must have a database selected in the sidebar before creating a table. If no database is active, the table list toolbar will not show the create option.

​
Opening the dialog

Click the + icon in the table list toolbar on the left sidebar. The Create new table dialog opens with two starter columns pre-filled: an id primary key with auto-increment, and a created_at timestamp. You can keep, edit, or remove these as needed.

​
Steps

1

Enter a table name

Type a name for your table in the Table name field. Use lowercase letters, digits, and underscores — avoid spaces and special characters to stay compatible with all MySQL clients.
2

Define your columns

Each row in the column list represents one column. For every column, fill in:
FieldDescription
NameThe column name.
TypeThe data type. Choose from the dropdown — options include INT, BIGINT, VARCHAR(255), VARCHAR(100), TEXT, DATE, DATETIME, TIMESTAMP, DECIMAL(10,2), FLOAT, BOOLEAN, JSON, BLOB, and more.
NullCheck this box if the column should allow NULL values. Leave it unchecked to require a value on every row.
PKCheck this box to make the column the primary key.
AICheck this box to enable AUTO_INCREMENT. Typically used with integer primary key columns so MySQL assigns a unique ID automatically.
To remove a column you no longer need, click the trash icon on that row.
3

Add more columns

Click Add (the + button above the column list) to append another column row. Repeat until all columns are defined.
4

Create the table

Click Create Table. MySQL UI executes the CREATE TABLE statement and the new table appears in the sidebar immediately.
Choosing the right data type upfront avoids costly migrations later. Use INT or BIGINT for numeric IDs and counters, VARCHAR with an appropriate length (e.g., VARCHAR(100)) for short strings like names or email addresses, and TEXT for long or variable-length content like descriptions or body copy. Use DATETIME when you need to store both date and time, or DATE alone when the time component is irrelevant.