Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench - default datatype sizes

In MySQL Workbench, is there a way to set the default datatype sizes?

For example, whenever I select the VARCHAR datatype, it defaults to VARCHAR(45).

In most cases, I set the length to VARCHAR(255).

So, to save myself some extra effort, how would I set the default to VARCHAR(255)?

like image 487
Force Flow Avatar asked Jun 17 '13 18:06

Force Flow


Video Answer


1 Answers

In version 5.2.47:

File > Properties > "Model" tab. In the "Column defaults" section for the "column type" field, change the value to VARCHAR(255).

like image 61
Force Flow Avatar answered Sep 30 '22 10:09

Force Flow