Getting error creating a basic sql table

Question

Here is the code I used to create the table:

CREATE TABLE product
(
ProductID int NOT NULL PRIMARY KEY,
ProductName varchar (50) NOT NULL,
Brand varchar (50) NOT NULL,
Price money NOT NULL,
Quantity int NOT NULL,
DateAdded date NOT NULL
)

Here is what I'm trying to insert:

INSERT INTO product
VALUE (100, 'Radio', 'Sony', 29.99, 30, '2012-08-22')

The error I'm getting is:

"Incorrect syntax near 'VALUE'."

Any ideas?

John Woo · Accepted Answer · 2012-09-28 02:28:36Z

1

use VALUES in you query,

INSERT INTO product 
VALUES (100, 'Radio', 'Sony', 29.99, 30, '2012-08-22')

answered Sep 28, 2012 at 2:28

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1705054 Over a year ago

Oh. My. God. I've spent, like, an hour on this. Thank you so much. I will now proceed to shoot myself in the face.

Vikdor · Accepted Answer · 2012-09-28 02:28:00Z

1

It's VALUES and not VALUE:

INSERT INTO product VALUES (100, 'Radio', 'Sony', 29.99, 30, '2012-08-22')

answered Sep 28, 2012 at 2:28

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

Collectives™ on Stack Overflow

Getting error creating a basic sql table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related