CODEWITHSUNDEEP
sqlmariadbmysql-error-1064
Tillo
Tillo

Reputation: 53

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use

I am having this error. I am using MariaDB.

ERROR 1064 (42000): 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 'hotel_name varchar(20), city varchar(10) )' at line 3

another error

ERROR 1064 (42000): 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 '' at line 1

create table hotel( hotel# int(10), hotel_name varchar(20), city varchar(10) );

How to solve it?

Upvotes: 5

Views: 41359

Answers (2)

Bill Karwin
Bill Karwin

Reputation: 562230

The # character is a comment character. Any characters following that comment until the end of the line is ignored. Read https://mariadb.com/kb/en/comment-syntax/

So this:

create table hotel(
  hotel# number(10),
  hotel_name varchar(10)
  ...

appears to the SQL parser as:

create table hotel(
  hotel
  hotel_name varchar(10)
  ...

This is missing a data type and a comma after the column hotel.

You can use special symbols like punctuation characters in your column names if you delimit them with back-ticks like this:

  `hotel#` int,

(Also use int not number because the latter is not a data type supported by MariaDB.)

But you would have to remember to use the back-ticks every time you reference that column in any query. It's simpler if you just avoid using special characters if you can.

This is easier:

  hotel_num int,

Upvotes: 2

siya
siya

Reputation: 73

The issue may be related to your use of "number(10)". That is not a valid MariaDB datatype. See the MariaDB datatypes here: https://www.mariadbtutorial.com/mariadb-basics/mariadb-data-types/

EDIT: MariaDB also does not allow # in identifier names. See the valid identifier names here: https://mariadb.com/kb/en/identifier-names/

Upvotes: 0

Related Questions