Mysql Question posted in
The official MySQL documentation can be found here.

Getting ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

So my query is

CREATE TABLE POSITION(
    ID INT AUTO_INCREMENT PRIMARY KEY,
    NAME CHAR(2) NOT NULL
);

and if i try to run this creation i receive

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 ‘POSITION(

But if a run the same query with POSITIONS or POSITION, it works fine.

Any idea why this happens?

I wanna know why i cant make a query with ‘CREATE TABLE POSITION’ on mysql

Tags:

2

Answers


  1. 0

    It’s because POSITION is a SQL keyword. You can’t use keywords as a any type of name such as table name

    POSITION is a function that tells index of first occurence of string

    https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_position

    Login or Signup to reply.
  2. 0

    You encountered a bug in MySQL’s documentation: While POSITION is not shown in MySQL’s reserved words, it is listed as a reserved word in MariaDB documentation (POSITION as an alias for LOCATE already existed in MySQL 3 as there was no MariaDB yet).

    Possible solutions:

    • Choose another name for the table

    • Quote tablename in backticks:

      CREATE TABLE `POSITION`( …..)

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search