MySQL skill boost-SQLyog advanced application

MySQL is the most used database of the company, it is cow and ox cow!

Everyone can design a database, from the deletion of the library to the run. But how to do better, faster, and more accurately build your MySQL database is a matter of concern (although many people have gone to big data, the idea is still generic).

In the absence of SQL desktop tools (or for Daniel), they are not used to desktop tools, are a word a word of the code out of the database, which is of course fundamental. However, it is not a good thing to be able to use tools efficiently, especially when you have to use tools on some occasions. Below I will summarize the MySQL desktop tool sqlyog Some applications, in summary, but also hope to ignite your casual eyes.

!!!

First, create new library new table, start your work;

Tables > Create table, Say no more, fill in the table name, select Engine, Character set

Second, check the history, record you do not SQL, on-line use;

History, when you don't know how to write SQL directly, you need to record the SQL from the interface operation, view historical records, find the changed SQL, and help the next time to improve the SQL ability to lay the foundation!

The so-called, see many, then know wide!

Third, add index, optimize your data;

Alter Table > Indexes > Columns Add index, add appropriate index, is a basic knowledge of database design.

　　

iv. Creating views, stored procedures, triggers, events, advanced MySQL applications, DBA work;

Creating views, stored procedures, triggers, events, advanced MySQL applications, these things should be DBA work, but as a general development or other type of job, it is necessary to understand.

In general, stored procedures and events can be more useful, and stored procedures can be used to manipulate multiple tables, with logic, and events to clean up some common work. Add one:

Five, quickly copy a benchmark database to another machine, so that synchronization is no longer troublesome;

When doing tests, there are situations where you do not have the things you need, and you know that there is an up-to-date library where you want to synchronize the data directly. Quick copy can be, synchronization is relatively troublesome!

Six, the interface design data, better display the relationship diagram;

Actually want to say the advanced, perhaps it is reflected here, enough intuitive, fast enough!

This is a good thing to do if you have to show the database structure to a leader or colleague. Intuitive visibility of relationships, and the ability to quickly edit fields (double-click fields to change), is handy for data structure audit changes.

Manage the foreign key, this piece I still have to study.

Vii. backup and export to ensure that your data is not lost;

This function is the most basic, directly right click Export, import can. However, for large data volume import, often error occurs, then, you have to delete some of the data, and then import.

Eight, the results of the inquiry, to optimize the display and modification;

SQLyog query results are not modified by default and need to be set manually. Sometimes an input box does not display properly and can be displayed using text.

　　

Each tool has its own strengths, reasonable use of good strengths, can make the work more smoothly!

MySQL skill boost-SQLyog advanced application