While the Quick-Add templates cover common columns, sometimes you need full control over column names, data types, and options. The Nobregas MySQL Panel table builder lets you add custom columns with precise configurations for any use case.
Adding a Custom Column
- Open the Table Builder (by navigating to Databases > Manage > Create Table).
- Enter your table name.
- Click the Add Column Manually button below the template buttons.
- A new blank column row appears with fields for configuration.
Configuring Column Options
Each custom column row has the following settings:
Column Name
Type a descriptive name using lowercase letters, numbers, and underscores. Examples: phone_number, total_orders, birth_date.
Data Type
Select from the dropdown menu:
| Data Type | Description | Example Use |
|---|---|---|
| INT | Whole numbers (-2 billion to +2 billion) | IDs, counts, quantities |
| BIGINT | Very large whole numbers | Large-scale counters, social media IDs |
| DECIMAL | Exact precision numbers | Prices, financial data, coordinates |
| VARCHAR | Variable-length text (up to 255 chars) | Names, emails, short strings |
| TEXT | Long-form text (up to 65,535 chars) | Articles, descriptions, comments |
| TINYINT | Small numbers (0-255) | Boolean flags, status codes |
| DATE | Date only (YYYY-MM-DD) | Birthdays, deadlines |
| DATETIME | Date and time (YYYY-MM-DD HH:MM:SS) | Event timestamps, schedules |
| TIMESTAMP | Auto-updated date/time | Created/updated tracking |
| JSON | Structured JSON data | Settings, metadata, flexible data |
Primary Key
Check this box if the column should be the table's primary key. A primary key uniquely identifies each row. Only one column should be the primary key (or use composite keys via SQL).
Auto Increment
Check this to have MySQL automatically generate sequential values (1, 2, 3, ...). This is typically used with INT primary key columns.
Nullable
Check this to allow the column to contain NULL (empty) values. Leave unchecked if the column must always have a value.
Default Value
Optionally enter a default value that gets used when a new row is inserted without specifying this column. Examples:
0for numeric columnsactivefor status columnsCURRENT_TIMESTAMPfor timestamp columns
Adding Multiple Custom Columns
Click Add Column Manually repeatedly to add as many columns as you need. Each column appears as a new row in the builder. You can mix Quick-Add templates and custom columns freely.
Removing a Custom Column
Click the X button on the right side of any column row to remove it before creating the table.
Best Practices for Custom Columns
- Choose the right data type — Do not use TEXT when VARCHAR is sufficient. Do not use VARCHAR for numbers.
- Set appropriate lengths — VARCHAR(50) for names, VARCHAR(255) for URLs and emails.
- Use DECIMAL for money — Never use FLOAT or DOUBLE for financial values.
- Make it NOT NULL when possible — Avoiding nullable columns simplifies your queries and reduces unexpected behavior.
- Add indexes later — For columns you will search or filter by, consider adding indexes via SQL queries.
