'What's wrong with the syntax of this create table query?

I've tried changing the table name to match and 'matches' but I still get the same error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''match' (r1 VARCHAR(5), r2 VARCHAR(5), r3 VARCHAR(5), r4 VARCHAR(5), r5 VARCH...' at line 1

CREATE TABLE 'match' (r1 VARCHAR(5), r2 VARCHAR(5), r3 VARCHAR(5), r4 VARCHAR(5), r5 VARCHAR(5));
mysqlsql


Solution 1:[1]

match is a reserved word, use matches again without the single quotes.

CREATE TABLE matches (r1 VARCHAR(5), r2 VARCHAR(5), r3 VARCHAR(5), r4 VARCHAR(5), r5 VARCHAR(5));

hope this helps.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 DickAK

Related Questions