How to Insert a New Row into a Table

Adding data to your MySQL tables is a core database operation. The Nobregas MySQL Panel lets you insert new rows using the SQL Query page — write a simple INSERT statement, click execute, and your data is saved instantly.

Navigating to the SQL Query Page

1. Log in at mysql.nobregas.org.
2. Click SQL Query in the top navigation bar.
3. Select the database containing your target table from the dropdown.

Inserting a Single Row

Type an INSERT statement in the query editor:

INSERT INTO users (name, email, active) VALUES ('Alice', 'alice@example.com', 1);

Click the Execute button. A success message confirms the row was added and shows the number of affected rows.

Understanding Column Requirements

When writing your INSERT statement, pay attention to data types:

Auto-increment columns (like id) should be omitted from your INSERT — MySQL generates the value automatically. Nullable columns can be set to NULL. Required columns (NOT NULL without a default) must have a value.

Inserting Multiple Rows

Use a single INSERT statement with multiple value sets for efficiency:

INSERT INTO users (name, email) VALUES
('Alice', 'alice@example.com'),
('Bob', 'bob@example.com'),
('Charlie', 'charlie@example.com');

Handling Errors

If your insert fails, the panel displays the MySQL error message. Common causes:

• Duplicate entry — You tried to insert a value that already exists in a UNIQUE or PRIMARY KEY column.
• Data too long — The value exceeds the column's maximum length.
• Incorrect data type — You entered text in a numeric column or an invalid date format.
• NULL constraint — A required column was left empty.

Read the error message carefully, fix the value, and try again.

Verifying Your Insert

After inserting, navigate to Databases > Manage > click the table name to browse the data and confirm your new rows appear.

Tips

• Check the table structure first (Structure tab) to know the exact column names and types.
• Always wrap string values in single quotes.
• Use NOW() for the current timestamp: INSERT INTO logs (message, created_at) VALUES ('test', NOW());