I'm trying to create a field named show inside of a table. however it gives me a syntax error because it's a reserved word. I'm using mysql 4.1.  No frontend. I've checked this <a href="http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html"> http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html</a> but it doesn't seem to help. I changed the name to shows and it works so I'm sure it has something to do with it being a keyword. This isn't THAT important but I feel it's something I should know how to do or at least know why it won't work. mysql> create table Races     -> (track CHAR(30) NOT NULL,     -> racedate DATE NOT NULL,     -> race INTEGER NOT NULL CHECK (race > 0),     -> win CHAR(30) NOT NULL REFERENCES Horses(horsename),     -> place CHAR(30) NOT NULL REFERENCES Horses (horsename),     -> show CHAR(30) NOT NULL REFERENCES Horses(horsename),     -> PRIMARY KEY (track, racedate, race)); 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 'show CHAR(30) NOT NULL REFERENCES Horses(horsename),