Level 1
Jul 27, 2022
9
Level 5
Migration auto increment not bigint
Hello,
How can I create a table with auto increment, primary key, id that is not bigint but normal int?
Level 5
@michaelsholadiran Sorry, I guess you did not understand my question, I'm trying to create a database table with migration.
Level 1
mysql database
just change the type of the field you want to increment to int(11) and check on the auto increment
Level 5
@michaelsholadiran so, you can't make it auto-increment with the migration? And the primary key, will it make this field primary key or do I have to go and do it manually as well?
Level 102
Yeah just https://laravel.com/docs/9.x/migrations#column-method-increments
$table->increments('id');
1 like
Level 5
@Sinnbeck Thanks, don't know how I missed that.
Level 1
or $table->id();
Level 102
@michaelsholadiran https://laravel.com/docs/9.x/migrations#column-method-id
The id method is an alias of the bigIncrements method
Level 1
@Sinnbeck oh i will check it out
Please or to participate in this conversation.