SQL Error in Table Creation

Question

I want to create table Books, My syntax:

enter image description here

What is wrong with my code?

Please post plain text (using the {} code markup tool), not screen shots. — Barmar
– Barmar, Commented Dec 22, 2014 at 16:56
The error would appear to be that you are using angle brackets instead of parentheses. — Gordon Linoff
– Gordon Linoff, Commented Dec 22, 2014 at 16:57

Barmar · Accepted Answer · 2014-12-22 16:57:40Z

4

You're using angle brackets (<>) where you should be using parentheses (()).

CREATE TABLE books (
    isbn INT PRIMARY KEY,
    title VARCHAR (20),
    price DOUBLE
);

answered Dec 22, 2014 at 16:57

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Comments

Prerak Sola · Accepted Answer · 2014-12-22 16:58:08Z

0

Try this:

create table books(isbn int primary key, name varchar(20), price double);

answered Dec 22, 2014 at 16:58

Prerak Sola

10.1k8 gold badges39 silver badges77 bronze badges

An explaination as to how this may fix the problem is required (and anyways, what is the difference with the original query?)

The code is functionally identical to the code in Barmar's answer. .