SQLyog graphical L database operation and Learning

1: First SQLyog as a graphical operation of MySQL tool, is a charge of the tool, but in the Kingdom of great power, any fee software can be cracked, the specific software installation does not do much narration, support the genuine, after all, as a developer, painstakingly developed software, but also hope to earn some money to support the family, Isn't it. OK, the following is a brief introduction of some common, convenient for later development and use

(Note that it may vary slightly depending on the version.)

2: The Open tool will appear as shown in the page, my account is root, the password is set by itself, the port number by default is 3306, and then click Connect

3: After clicking on the connection appears as shown, may be due to different versions, the interface slightly differences, please self-brain repair

4: On the left this module mouse right click click Create Database

5: Click to create the database after the pop-up shown below, output their own database name, the base character set select UTF-8 can be. Database Collation Selection Default

(This is my database name)

6: Then you can see the database you created on the left side of the plate. Create a database and then you can create a data table.

7: In the table this folder, right-click Create table, as shown in

8: Create a table The top page is the page as shown.

9: As shown, first write the table name, and then write column name, data type, length, primary key, non-empty, sign bit, self-increment and so on, write well later save can.

10: Click Save appears as shown in the page, click Yes

11: Then in the left module you can see the data table you created (and so on, you can create multiple databases or data tables.) ）

12: After the creation of the data table can be used to increase the deletion (CRUD), such as my query or query this page in the operation of the command, such as, I first queried, there is no data, just have their own field name, but I wrote the Insert Insert command, Querying the following plate again shows that the contents of the data table already exist after inserting. (When the query page has multiple commands, use the mouse to sweep the command, and then press the execution button)

The 13:sqlyog visualizer is very powerful and is often used in the future to develop visual tools that are very fast and easy to develop. The following is a simple to write about frequently used. As shown, the mouse right-click on the data table you created, and then you can see a lot of features, such as opening a table, creating a table, changing the table (if you add new fields or changing data types, etc.), more table operations, you can delete a table or rename a table, and other features such as indexes, views, etc. Skilled use of visualization tools will greatly improve the efficiency of their own development, of course, there are other visual tools development database.

14: Backup and export, develop in the future, in order to avoid unnecessary accidents, you can back up and export the database, right-click the database you created, and then choose to schedule a backup or backup the database. (Details of their own brain supplement, here only to do demo)

15: When using PowerDesigner design database can be imported into the sqlyog inside, here can right click on their own created database, and then choose Import, Import external data or Execute SQL script, detailed self-brain repair

16: Set foreign KEY constraints, such as the + number in the query, click on the new schema designer, perhaps due to different versions, just find this new schema designer. Click to open

17: Open the Schema Designer as shown in

18: Here's how you can easily do this by dragging the table you created with your mouse onto the Schema Designer page, as shown in.

19: Finish the above operation can point the mouse to the ID of a data table and then directly onto the ID of another data table, appear as shown in the page, click Save to complete the design of foreign keys, specific who do the foreign key, self-brain repair, here is only an example of how to operate it.

20: Click Save to display the following page, that is, to complete the foreign key settings.

21: Increase the row of the data table or delete the row of the data table, as shown, click the + or-number can add or delete rows of the data table, due to the different version, may slightly differ, please self-brain repair

(after the operation of the above you will feel the use of this graphical development tools gray often convenient, feel the use of more skilled, more practice several times. )

22: Can also be large-scale operation, such as, first use the mouse to select, and then click on the specified query or F9 can be inserted. Details such as

23: Complete the insert operation, you can query first, detailed as can be completed.

24: Use SQLyog to create an index after the mouse right click on the creation of a good data table, and then click Manage Index, open as shown in the page, see that the field is indexed, due to different versions, the page may be different, please self-brain

SQLyog graphical L database operation and Learning