Z
Z
zachfischer2021-02-18 16:16:41
SQL
zachfischer, 2021-02-18 16:16:41

Near "vacation": syntax error?

I create a table like this:

CREATE TABLE Отпуск
('Код отпуска' INTEGER PRIMARY KEY,
'Тип отпуска' CHAR (100) NOT NULL,
'Оплата отпуска' FLOAT CHECK ('Оплата отпуска' > 10000),
'Льготы по отпуску' FLOAT NOT NULL);


When I try to insert data, I get this error:

near "vacations": syntax error

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey Karbivnichy, 2021-02-18
@zachfischer

What is a DB. What are you using for the request?
Checked your query in sqlite3, completed without errors.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question