failed migration database with laravel 5.3

Question

if the code like this : $table->integer('no', 3);, it's failed

if the code like this : $table->integer('no');, it's success

why when I use lenth, it failed to migrate db?

Alexey Mezenin · Accepted Answer · 2016-11-25 10:53:17Z

1

That's because integer() second parameter is $autoIncrement which accepts true or false. You can't pass 3:

public function integer($column, $autoIncrement = false, $unsigned = false)

answered Nov 25, 2016 at 10:53

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

samuel toh Over a year ago

so conclusions can not use a length?

Alexey Mezenin Over a year ago

Yep. If you're looking for smaller integers, check out tinyInteger and smallInteger types.

samuel toh Over a year ago

Thank you very much

Community · Accepted Answer · 2017-05-23 10:30:16Z

0

You cannot specify the length of an integer column, if that is what you are trying to accomplish. See this answer here for a full explanation https://stackoverflow.com/a/25772960/7202919

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Nov 25, 2016 at 14:59

httpoz

965 bronze badges

1 Comment

samuel toh Over a year ago

I had see it. The link says it can not using length

Collectives™ on Stack Overflow

failed migration database with laravel 5.3

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related