SQLyog

SQLyogThe Chinese version is a professionalGraphic management software, SQLyog is simple to operate and powerful, and can help users easily manage their MYSQLdatabase, SQLyog Chinese version supports exporting in multiple data formats, which can quickly help usersbackupandRecover data, and can run quicklySQLScript files provide convenience for users. Friends who like SQLyog, come to Huajun Software Park to download and experience it!

The new version of mysql client SQLyog Ultimate 12.0.8.0 in 2015, shared by netizens, supports auto-complete, can display auto-complete help in the SQL editor, rebuild the label file at startup, remember the column width modified by the user, and intelligent keyword/function/default value processing. Can create new MYSQL/HTTP/SSH/SSL connections. Advanced functionality allows you to set the background color and foreground color, which are used in the Object Browser only for that connection. Database management can copy databases to different hosts or databases, create/change databases, backup or export databases.

SQLyog64-bit perfectly supports 64-bit WIN7 and later versions of the system, can connect to the designated MYSQL host, supports the use of HTTP pipes and /SSH/SSL, can create new tables, views, stored procedures, functions, triggers and events, and supports deletion and truncation of the database. It supports dumping the database and saving the database to SQL. The editing function can find/replace specified content, list all or matching tags, manage tasks created by SQLyog, use respective task wizards to create tasks, etc. It has lifted usage restrictions, is safe and free, and friends in need may wish to download and use it!

Features of sqlyog Chinese version software

​ 1. SQLyog is based on C++ and MySQLAPI programming;

​​ 2. Convenient and fast database synchronization and database structure synchronization tools;

3. SQLyog has easy-to-use database and data table backup and restore functions;

​ 4. SQLyog supports importing and exporting data in multiple formats such as XML, HTML, and CSV;

5. Run batch SQL script files directly, extremely fast;

​​ 6. The new version of SQLyog adds powerful data migration.

sqlyogChinese version function introduction   

    2. SQLyog creates or edits data tables with an intuitive table interface.

​​ 3. Carry out index management and create or delete databases.

​​ 4. Manipulate various permissions of the database: libraries, tables, fields.

5. Edit BLOB type fields, supporting Bitmap/GIF/JPEG formats.

​ 6. Output the data table structure/data as SQL script.

​ 7. SQLyog supports input/output data as CSV files.

​ 8. SQLyog can output the database list as an HTML file.

​​ 9. Create logs for all operations and personal collection management of operation statements.

10. SQLyog supports syntax highlighting and quickly backs up and restores data.

11. SQLyog displays results in GRID/TEXT format and supports client selection and filtering of data.

12. Execute large SQL script files in batches.

​​​ 13. Quickly execute multiple queries and be able to return record sets of more than 1,000 records per page, and this operation is generated directly in memory.

SQLyog Chinese version installation tutorial

​​ 1. First download and unzip the SQLyog installation package on this site, then click on the exe installation file and start selecting the language.

2. First enter the SQLyog Chinese version installation wizard interface and click Next directly.

​​ 3. Next, a license agreement in English will appear. Select to accept the terms directly, and then click Next

​​ 4. Enter the installation location interface, you can choose to install to the C drive by default or click Browse to perform a customized installation

5. Enter the installation interface, wait patiently for a moment, and you can enter the SQLyog software for use.

SQLyog Chinese version usage tutorial

      1.How to create a database in SQLyog?

The first step is to right-click the root node -> Create database.

The second step is to fill in the database name, select the default character set, etc. and click OK.

      2. How does SQLyog back up and restore the database?

      2.1 Steps to back up database

Step 1: Right-click the database to be backed up->Backup/Export->Backup Database.

The second step is to make settings according to your needs on the SQL dump interface.

​ ​ 1: Data, structures, or both can be backed up as needed.

​ ​ 2: Select the location where the backup file is stored.

​ ​ 3: Check the content you want to back up.

​​ 4: Select the content to be written to the file according to your own needs, such as Create Database, Use Database and other statements.

The third step is to click Export.

      2.2 Steps to restore database with SQLyog

The first step is to right-click the database you want to restore->Import->Execute SQL script.

The second step is to select the previously backed up files in the restore database interface.

The third step is to click ‘Execute’.

      3.SQLyogSome operations on database tables

      3.1 Back up table data

                                                                    Right-click and select the table under a certain database -> Backup table as SQL dump.

The following steps can refer to the method of backing up the database.

      3.2 Restoring table data is the same as restoring the database.

      3.3 How to view and modify table structure and indexes

The first step is to right-click the table -> Change Table to open detailed information about the table.

The second step is to modify the table structure, index and other information in the opened interface. For example, modify the index attribute to FULLTEXT

Frequently asked questions about SQLyog Chinese version

      1. SQLyog garbled problem

      First case:

​​Enter the following code under SQLyog and execute it all

SET character_set_client = utf8;

SET character_set_results = gb2312;

SET character_set_connection = utf8;

If the above does not work, you can also change it to Gbk. Just change the text encoding of your data to the corresponding encoding type and you'll be fine. Given the code for Gbk:

SET character_set_client = gbK;

SET character_set_results = gbK;

SET character_set_connection = utf8;

But it doesn’t work after restarting SQL.

​​ 2.Tools->Preference Base->Editor Modify Fonts

After the modification is completed, just restart SQLyog.

      Second case:

To support the complete Chinese character set, MySQL should be set to GBK encoding.

Find my.ini in the MySQL installation directory and modify utf8 to gbk, as follows:

        default-character-set=gbk

There are two places that need to be modified.

​​Restart the MySQL service.

As a result, I used SQLyog to view the data table and it showed normal.

      2. How to import mysql database into SQLyog?

The first step is to open the SQLyog software, enter the password, click Connect, and open the software interface. It should be noted that mysql needs to be installed first, as shown in the figure below:

The second step is to create a database with the same name as the database to be imported. For example, if you want to import a shop.sql database here, first create a database named shop, as shown in the following figure:

The third step is to enter the shop database name and click Create, as shown in the figure below:

The fourth step is to click on the newly created database, then click Database->Import->Import the database from SQL dump file, as shown in the figure below:

The fifth step is to select the path to import the database and click Execute. After execution, click Finish, as shown in the figure below:

The sixth step is to open the tables of the database. You can see that each table has been imported, as shown in the figure below:

SQLyog vs.MYSQLSoftware comparison

      MySQLThe database is a small relational database management system. Due to the small size, fast speed and low cost of the MySQL database, especially the characteristics of open source, MySQL is generally chosen as the website database for small and medium-sized website developers. MySQL has very high execution performance, very fast running speed, supports multiple platforms and various development languages, provides users with a secure password system, is suitable for many small and medium-sized websites, and is very easy to use.

SQLyog is an easy-to-use, fast and concise graphical management tool for MYSQL databases. It can effectively manage your database anywhere, and it is completely free!

MySql is for managing background data, SQLyog is a database graphical management tool, MySQL must be used to manage database data, and SQLyog allows you to intuitively observe the MySQL background data. The two are used together.

SQLyog Chinese version update log

SQLyog12.09 update:

​ 1. The ALTERTRIGGER introduced in 12.08 collides. This crash is due to SHOWCREATETRIGGER being unavailable (in MySQL servers prior to 5.1 or due to a MySQL bug). The patch in 12.08 fails in this environment. We will now revert to the old logic if SHOWCREATETRIGGER is unavailable or returns an error or empty string.

​ ​ 2. The issues listed above may cause a crash in mode synchronization.

3. Importing external data will map the MSSQLvarchar(max) data type to MySQL'varchar'. The ODBC driver for MSSQL will return an empty string for varchar(max) columns. We now map MSSQLvarchar(max) to the MySQL 'TEXT' data type as the default value.

​ 4. After executing queries in batches, the Query Analyzer will now be disabled. Early SQLyogEXPLAINed the first interpretable statement in a batch execution. This arbitrary choice caused confusion and, in the case of a batch execution of DROPTABLE, could lead to errors when the table referenced in EXPLAIN no longer existed.

5. SQLyog restricts users to enter table comments exceeding 60 characters. Now if the user is using MySQL server >5.5.3+, he/she will be able to enter table comments up to 2048 characters.

​ 6. Fixed a crash on "Copy database to different host". Only the SQLyog community is affected. This bug was introduced in SQLyog11.52.

​​ 7. Corrected the Korean translation with a patch patched by Korean users.

      Statement: Due to copyright and manufacturer requirements, Huajun Software Park provides the official Chinese version of SQLyog