Recently, I started to use MySQL database for project development. Although I used MySQL database in university, I used Navicat for again MySQL, in addition to the familiarity of other basic operations seem to have forgotten, now the use of problems as a blog record, but also for their own future use of more familiar than now.
demand
Table replication in the database
- Because you create a table that has many of the same standard fields, the quickest way is to copy a table and then add some changes.
- But try to operate through the interface, it seems not to achieve
- You can copy tables by modifying SQL statements on the command line and then executing SQL statements
Export of SQL statements in a view
- When using PowerDesign to create a database model, you need to export the SQL statements of database tables and views in MySQL database
- The SQL statement of the database table can be right – click everywhere to have the SQL statement export
- SQL statements from database views cannot be exported this way
The solution
Replication of database tables
- Click database right click to see the command line interface options in the drop-down menu box, click the command line interface options to enter the command line interface
- Copy the SQL statement of the table on the command line interface. After modifying the SQL statement field, you can copy the database table
Export of SQL statements in a view
- Start by backing up the view of the database
- Extract the SQL in the backup database view
