Inserting Rows

With a table ready, you can start adding rows to it. Each row is written as a set of field values that match the table's type:

insert into main.users { id: 1, name: "Alice" };

Try adding a few more users:

insert into main.users { id: 2, name: "Bob" };
insert into main.users { id: 3, name: "Charlie" };

Since id is the primary key, every row must have a unique one. Inserting a duplicate id will produce an error - give it a try if you're curious.