what wrong with this syntax in dbeaver?

Question

insert into warranty values ('p10', '6-year warranty ', 89)

insert into warranty values ('p11', '7-year warranty ', 24)

insert into warranty values ('p12', '8-year warranty ', 45)

insert into warranty values ('p13', '9-year warranty ', 25)

select * from warranty

Answer 1

Hey Bryce,

There isn't enough information to really tell you what is wrong with your queries. We don't know what your table schema looks like. Here are a few things to check

1. Depending on the database server, put semi-colons after your inserts.
2. We don't know what warranty table looks like, so either explicitly specify the columns you are inserting, or check to make sure the number of values you are inserting match the number of columns in the warranty table.
3. Meaning, you are only inserting 3 values into the warranty table based on your sql statements. If your warranty table has 10 columns you are going to get an error based on implicitly inserting 3 columns into a 10 column table.
4. So to fix this, you'd either have to insert 10 values or explicitly specify the columns being inserted into. For example
5. INSERT INTO warrant (warranty_id, warranty_description, age) VALUES ('p13', '9-year warranty', 25);
6. Within whatever database server you are using, you are not using the correct database/schema.
7. Ex: in SQL Server, if you don't specify the database via USE statement (or the drop down in the top left), your default database may be master which won't allow you to insert the values you are looking to insert.

I'd start with checking those few items, if you are still having issues feel free to provide more details as to what the error may be.