Is there anything convenient to create a table structure MySQL tool?

Create such a table down with navicat good tired! Do you have any other handy and useful MySQL tools? method is also OK
(PS: 请忽视我臃肿不堪的表结构，毕竟我是一个新人 )

Reply content:

Create such a table down with navicat good tired! Do you have any other handy and useful MySQL tools? method is also OK
(PS: 请忽视我臃肿不堪的表结构，毕竟我是一个新人 )

Well, it's best to write SQL statements. ^_^
There are also tools that are mapped by code, such as various UML diagram transformations, but not recommended.

In fact, the tools are mainly auxiliary, such as the navicat you are using now, one is to accomplish the goal (get the table structure), and the second is to be familiar with deepening the understanding of SQL statements. If one day you can get rid of these tools, the direct SQL statement is completed, so the efficiency is the highest (of course, must be perfected, otherwise, there is a mistake, your tangled long time, it is not efficient)

PS: I mainly make the front end, I play back end, so for SQL tools, such as SQL statements are also just familiar, will use only, mutual encouragement!

1. Handwritten SQL is the fastest and most convenient

2. Tool Flow

   • WinUnderPowerDesigner

   • Mac/LinuxUnderMySQL Workbench

Migration AH.

You're not handwriting, it's a graphical tool.

or write SQL.

See you tagged PHP, to understand the next migration bar, with PHP code to generate MySQL table, good use, migration is also convenient.
Yii2,laravel Many frameworks are made up of this module.

Except for the YAF I'm using now. (Manual squint)

No, handwritten table SQL is the fastest, migration also belongs to handwriting, but the format is different. Handwritten tables because you can paste the copy directly, and then change the line, with the tool is usually no way to copy the field declaration process.

