Maria DB Server

Question

I land up in an error stating:

Error Code 1064: You have an error in your sqlsyntax; check the manual that corresponds to your MariaDB Server syntax for the right syntax to use

CREATE TABLE 'company'.'employee'(
'fname' VARCHAR (10) NOT NULL,
'mname' VARCHAR(2) NULL, 
'lname' VARCHAR(10) NOT NULL,
'ssn' CHAR(9) NOT NULL, 
'bdate' DATE,
'address' VARCHAR(20) NOT NULL,
'sex' CHAR NULL,
'salary' DECIMAL (10, 2) NULL,
'super_ssn' CHAR(9) NULL,
'd_no' INT NOT NULL,
PRIMARY KEY ('ssn'));

Possible duplicate of [When to use single quotes, double quotes, and back ticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-back-ticks-in-mysql) — Madhur Bhaiya, Dec 01 '18 at 07:20

Imam Digmi · Accepted Answer · 2018-12-01T07:15:12.833

Use ` instead of ' (single quote),

You should write it like the following :

    CREATE TABLE `company`.`employee`(
      `fname` VARCHAR (10) NOT NULL,
      `mname` VARCHAR(2) NULL,
      `lname` VARCHAR(10) NOT NULL,
      `ssn` CHAR(9) NOT NULL,
      `bdate` DATE,
      `address` VARCHAR(20) NOT NULL,
      `sex` CHAR NULL,
      `salary` DECIMAL (10, 2) NULL,
      `super_ssn` CHAR(9) NULL,
      `d_no` INT NOT NULL,
      PRIMARY KEY (`ssn`)
    );

Actually, the ` symbol is optional, but it is used if the field names, tables, or databases are the same as keywords or MySQL clauses whose purpose is that MySQL is not confused with what you mean in the query.

For example :

SELECT column FROM `char`

I use ` symbol because the name of the table is the same as keyword on MySQL i.e CHAR() (but naming like that is a bad way), so keep in mind that if you write SQL Query you must decide to use the ` symbol

hope this can help you.

with pleasure @SID, please mark my answer as your solution :) — Imam Digmi, Dec 01 '18 at 07:17

Maria DB Server

1 Answers1