Error in Create Table Syntax MYSQL

Question

This is my create table syntax:

Create table Recipe(
    Recipename varchar(30), 
    Cuisine varchar(20), 
    Skilllevel varchar(13), 
    Ingredients varchar(400), 
    Procedure varchar(1000), 
    Cookingtime int(30), 
    Category varchar(10), 
    Restrictions varchar(15)
);

I'm not able to identify the error in this. Please do help. Thanks

Procedure is a reserved word. Need another name or surround it with backticks. — Paul T.
– Paul T., Commented Jul 25, 2017 at 19:59
Sit down with any basic introductory book or tutorial. This is a long way from a sensible design. And what the hell is int(30)? — Strawberry
– Strawberry, Commented Jul 25, 2017 at 21:58

Paul T. · Accepted Answer · 2017-07-25 20:01:02Z

1

Procedure is a reserved word. Need another name or surround it with backticks.

answered Jul 25, 2017 at 20:01

Paul T.

5,02712 gold badges48 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Valli Pichappan Over a year ago

Thank you so much!

Norbert · Accepted Answer · 2017-07-25 20:10:34Z

1

INT doesn't need a (30) value + you cant use word Procedure. Changed it to Procedures

 Create table Recipe(
         Recipename varchar(30), 
         Cuisine varchar(20), 
         Skilllevel varchar(13), 
         Ingredients varchar(400), 
         Procedures varchar(1000), 
         Cookingtime int, 
         Category varchar(10), 
         Restrictions varchar(15));

edited Jul 25, 2017 at 20:10

Norbert

6,1043 gold badges19 silver badges40 bronze badges

answered Jul 25, 2017 at 20:00

Isaiah3015

4913 silver badges11 bronze badges

1 Comment

Valli Pichappan Over a year ago

Thank you so much!

Tre · Accepted Answer · 2017-07-25 20:06:59Z

0

Looks like Isaiah answered your question but I wanted to add: depending on what kind of format you want the Cookingtime to be in, you could use the time datatype for long cook times (several hours) or keep using int if you are using minutes.

answered Jul 25, 2017 at 20:06

Tre

343 bronze badges

Collectives™ on Stack Overflow

Error in Create Table Syntax MYSQL

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related