I have just started studying SQL, and an excersize requires me to use Base to execute the following SQL command (executed through Tools-->SQL...):
Code: Select all
CREATE TABLE "tbl_customers" ("customer_id" INTEGER IDENTITY, "first_name" VARCHAR(50), "last_name" VARCHAR(50), "phone" VARCHAR(25), "email" VARCHAR(30), PRIMARY KEY ("customer_id"));
This code has been verified by three different sources as a valid and workable command and has been tested in Open Office 4.1.3, which is the same version I have installed on my Windows 7 computer.
Whatever I do, the following error message is shown:
Code: Select all
1: syntax error, unexpected NAME, expecting ')' or ','
Why is this command not working (and only on my computer apparently). At this point I doubt that the command is wrong, I believe there is something else. Maybe my installation, maybe something I don't know. I have uninstalled and reinstalled Open Office too, but it didn't change anything.
20170921154801_screenshot.png