MySql gives an error for no reason at all?

Question

I am writing an mysql program (using the command line editor):

CREATE TABLE FLIGHTS (
FL_NO  VARCHAR(10) NOT NULL PRIMARY KEY,
STARTING VARCHAR(20) NOT NULL,
ENDING VARCHAR(20) NOT NULL,
NO_FLIGTHS INT NOT NULL,
NO_STOPS INT NOT NULL
);

this is somehow gives an error which is surprising. any idea?

Error message: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'STARTING VARCHAR(20) NOT NULL, ENDING VARCHAR(20) NOT NULL, NO_FLIGHTS INTEGER N' at line 3

What have you tried to resolve the problem? Where are you stuck? — Nico Haase, Feb 10 '22 at 15:00
MySQL's error 1064 shows you the part of the SQL statement coming immediiately *after* the part it can't understand. So backing up from `STARTING VARCH...` you ge the first line of the table definition. — O. Jones, Feb 10 '22 at 15:02

score -1 · Answer 1 · answered Feb 10 '22 at 14:59

-1

STARTING and ENDING are keywords, and MySql does not accept keywords as column names, changing them should help...

answered Feb 10 '22 at 14:59

11 B 210109 GATHIK JINDAL

5
2

This is not entirely true. – Shadow Feb 10 '22 at 15:07
MySql does not accept RESERVED as column names, -Reserved words are permitted as identifiers if you quote them as described in Section 9.2, “Schema Object Names”: https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-S – P.Salmon Feb 10 '22 at 15:08

MySql gives an error for no reason at all?

1 Answers1