DbForge Query Builder for MySQL

DbForge Query Builder for MySQL - Is a program for easily and quickly building SQL queries to MySQL and MariaDB databases. The program allows you to create SQL queries visually without writing code, as well as using the SQL code editor to write the text of the request manually. When writing SQL queries manually, the code completion tools make it much easier to compose queries. A user-friendly graphical interface allows you to flexibly configure the sampling parameters from the MySQL and MariaDB databases. Basic Functionality DbForge Query Builder for MySQL:
Easy and convenient navigation to databases The database explorer makes it easy to navigate through databases through a tree-like list that shows the structure of the database and allows you to view all objects. Visual creation Queries with joins and subqueries When working with dbForge Query Builder for MySQL, you can use the visual query builder. Using drag-and-drop operations, you can create complex SQL queries with a few mouse clicks. Expression Editor The built-in expression editor allows you to add complex sample conditions and grouping criteria to the SQL query using the mouse. Creature Queries in a text editor You can use the built-in SQL query editor to write the text of queries manually. The editor has the functions of code autocompletion and syntax highlighting, which significantly reduces the time of writing a request. View the query execution plan DbForge Query Builder for MySQL allows you to view detailed SQL query execution plans, which allows you to analyze aspects related to query performance. Visual query profiler allows you to find out how much time it takes to read from disk, lock tables, unload into memory. Very useful information can be the amount of memory used or the processor load at each stage of the query. Also, you can view the differences in profiling results after making changes. Working with query results DbForge Query Builder for MySQL has all the necessary tools for working with data that were returned by the server in response to the request. You can view the contents of fields, sort, group and filter the result set of records. Export query results The program allows you to export data to 10 popular formats: HTML, Text, MS Excel, MS Access, RTF, PDF, XML, CSV, DBF, ODBC. System requirements:

• Operating system Microsoft Windows XP / 7/8 / 8.1 or Windows Server 2008/2012
• .NET Framework 3.5SP1, 4.0, or 4.5
• A processor with a clock speed of 2 GHz or higher
• 150 MB of free hard disk space to install the program
• 1024 MB of RAM