Add a row to a table

OVERVIEW

Introduction

In this lesson, we will learn how to add a row to a table. In the first section, we will show how to add a row using DB Browser. In the second section, we will add a row using an SQL statement.

Insert a row with DB Browser

Browse table
Browse table

To add a row to a table, you must first select the table (for instance the table Students). Use the Browse Data button (see red arrow in the screenshot above) to open the selected table.

Insert row
Insert row

To add a row, use the small button Insert a new record in the current table (see red arrow in the screenshot above). An empty row will be added in which you can enter the data. With the button Delete the current record (see blue arrow in the screenshot above), you can delete any incorrect rows. All changes must be confirmed with the button Write Changes (see yellow arrow in the screenshot above).

Add a row with an SQL statement

The INSERT statement should be used to add a row to a table:

INSERT INTO table_name
   [(column_name1, column_name2, column_name3...]
   VALUES (value1, value2, value3...);

In the simplest form of the SQL statement, the list of column names can be omitted. In that case, the list of values must match all columns in the table. The following statement is completely correct:

INSERT INTO Courses
   VALUES (45, "Python programming");

We entered and executed the above instruction in DB Browser:

INSERT statement
INSERT statement

The complete SQL statement (including column names) would then look like this:

INSERT INTO Courses
   (CourseId, CourseName)
   VALUES (65, "Web design");

And once again: don’t forget to confirm all changes with the Write Changes button in DB Browser:

The contents of the table can, of course, be checked using the Browse Data button in DB Browser:

Courses
Courses