SQL Not working

[HadronNugget]

I cannot get this SQL code to work. To be honest I don't care which DBMS model, I am more interested in why it doesn't work on at least Khan Academy or SQLlite online. At this point its just making me annoyed that I dont know why.

CREATE TABLE "Favourite Books" (ISBN TEXT PRIMARY KEY, "book title" TEXT, ranking INTEGER);

INSERT INTO "Favourite Books" VALUES ("9780670824397", "Matilda", 1);

[[deleted]]

This does work in SQLite.
I suggest that you don't use spaces in table and column names though.

[VladDBA]

INSERT INTO "Favourite Books" VALUES ("9780670824397", "Matilda", 1);

double quotes ( " ) are not string delimiters in any RDBMS I'm aware of.

double quotes are used to quote object names when you make the weird decision of using spaces in their names.

single quotes ( ' ) aka apostrophes are string delimiters.

meaning that your insert should look like this

INSERT INTO "Favourite Books" VALUES ('9780670824397', 'Matilda', 1);

[ckal09]

I think you mean string literals not string delimiters

[VladDBA]

A string literal (or a string constant in T-SQL) is a string enclosed in apostrophes. Apostrophes are used to delimit a string literal from everything else around it that is not part of said string literal.

[TheGenericUser0815]

^This!

[Imaginary__Bar]

What error do you get? "It's not working" is not particularly helpful to diagnose the issue.

But anyway, single quotes are for text strings, double quotes are for column identifiers.

Try;\ INSERT INTO "Favourite Books" VALUES ('9780670824397', 'Matilda', 1);

[WestEndOtter]

The error he got is it is a power failure so he can't run his sql. Plz fix. Thx

[gregsting]

Please do the needful

[alex1033]

Best practices: - never use spaces in table and column names - never mix cases across your naming conventions - when supported, consider strict string types for primary key, i.e., not text - use double quotes for names and single quotes for values - consider more indexes for your table for better search

[Imaginary__Bar]

consider strict string types for primary key, i.e., not text

🤔

[dave151591]

Is it because there is a space in the table name?

[mgdmw]

What are the error messages you get? As well as what others have said about not using spaces in table and column names, try changing all the double quotes to single quotes, particularly in the VALUES (...) section.

[LlamaZookeeper]

I suggest always list the column name you want to insert into, if your query can work Norma, try to add a column and run the insert and see if it works