How to create TINYINT(1) datatype in mysql database?

Question

I'm creating table in mysql database but it is giving error...

    CREATE  TABLE IF NOT EXISTS `EC_TIMETABLE` (
  `S_ID` VARCHAR(30) NOT NULL PRIMARY KEY,
  `SKILLSET_ID` VARCHAR(30) NULL ,
    START_DT DATETIME NULL,
    END_DT DATETIME NULL,
    REPEAT TINYINT(1) NULL,
    ALL_DAY TINYINT(1) NULL,
    CLASS_DURATION INT NULL,
    COURSE_DURATION INT NULL,
    REPEAT_TYPE VARCHAR(30) NULL,
    REPEAT_EVERY INT NULL,
    REPEAT_DAYS VARCHAR(100) NULL,
    REPEAT_FROM DATE NULL,
    REPEAT_TO DATE NULL,
    COURSE_FEE INT NULL,
    ATTENDEE_MIN INT NULL,
    ATTENDEE_MAX INT NULL,
    SEARCH_KEY TINYTEXT NULL,
    FOREIGN KEY (`SKILLSET_ID` )
    REFERENCES `EC_SKILLSET` (`S_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

But it giving Error:

#1064 - 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 'REPEAT TINYINT(1) NULL, ALL_DAY TINYINT(1) NULL, CLASS_DURATION INT NULL' at line 6

How to solve this one..

score 3 · Accepted Answer · edited Jul 22 '21 at 16:29

3

REPEAT is a Reserved Keyword. You can still use it but you need to wrap it with backticks.

`REPEAT` TINYINT(1) NULL,

MySQL Reserved Keywords List

I suggest that you don't use such keywords on the reserve list to avoid neck pain in the future.

edited Jul 22 '21 at 16:29

rlorenzo

1,358
1
13
16

answered Mar 21 '13 at 07:40

John Woo

258,903
69
498
492

score 1 · Answer 2 · answered Mar 21 '13 at 07:40

1

I believe REPEAT is a keyword in MySQL. Try renaming your column.

answered Mar 21 '13 at 07:40

Stijn Haus

481
3
18

score 1 · Answer 3 · edited May 23 '17 at 12:11

1

First you shouldn't use REPEAT because this is reserved by mysql and secondly take a look at MySql Error 150 - Foreign keys because you have another error concerning foreign keys.

edited May 23 '17 at 12:11

Community

1
1

answered Mar 21 '13 at 07:42

pauel

908
10
26

what's wrong with the foreign key? – John Woo Mar 21 '13 at 07:43
ahh sorry stupid me, it should work just fine. Sorry, responded too fast. – pauel Mar 21 '13 at 07:44

How to create TINYINT(1) datatype in mysql database?

3 Answers3