CODEWITHSUNDEEP
sql-serversql-server-2008
Nistor Alexandru
Nistor Alexandru

Reputation: 5393

Error when inserting data

Hi I have created a products table for a database but when I try to insert data into it I get this error:

enter image description here

This are the table fields:

enter image description here

The only fields that are required are the first 6 and.This first is the index that is set to autoincrement and the other 5 I have added them.

What is the problem here?

Upvotes: 1

Views: 66

Answers (1)

immayankmodi
immayankmodi

Reputation: 8600

I assume that you have assigned a PK to autoincrement... so try this,

INSERT INTO products (brandid, subcatid, productname, productprice, productimagepath) VALUES (111,'P111',111,'P111.jpg');

Letm me know it helps you or not ?

Upvotes: 1

Related Questions