Using this efficient and reliable application, you can easily view and manage MySQL databases, with efficiency and minimal effort. #MySQL manager #Database manager #Edit database #MySQL #SQL #Query
X-SQLyog is a comprehensive software solution meant to serve you in managing the contents of your MySQL database, supporting remote connections and allowing you to create tables, run queries, as well as backup or synchronize data.
Following the quick installation of the program, you can launch it and connect to your database by providing the necessary details.
Once connected, the main window of X-SQLyog displays the database tables in tree view mode, enabling you to browse through them, execute queries, look up certain items and cut, copy or paste data using the functions in the tool’s ribbon.
In order to access your MySQL database, you will need to enter a connection name, the host address, username, password and port, and some additional details, such as the ‘Session Idle Timeout’.
The left-side panel feature the database tables allows you to double click on various nodes in order to reveal their contents in tree view, accessing the items that you need to work with and edit, create or delete entries.
The ‘Edit’ operations include a wide range of options, like ‘Execute Query’, ‘Execute Explain’, ‘SQL Formatter’, ‘Cut’, ‘Insert From File’ and several others. X-SQLyog lets you ‘Create’ a number of objects in your database, for instance ‘Table’, ‘Stored Procedure’, ‘Function’, ‘Trigger’ or ‘Event’. Optionally, you can ‘Drop’ or ‘Truncate’ the database, as well as run backup operations.
Moreover, existing or newly created tables can be opened, altered, renamed, truncated, dropped, reordered or duplicated. You can also manage columns and indexes, flush the database or ‘Execute SQL Script’.
To summarize, X-SQLyog is an advanced and reliable application meant to function as a GUI for managing and editing the contents of SQL databases more swiftly, thus significantly simplifying your work.
What's new in X-SQLyog Community 12.2.5 Rev 14:
- Features:
- Added basic support for the JSON datatype as of MySQL 5.7.8+ and MySQL Cluster 7.5.2+. The datatype is now available in the CREATE/ALTER TABLE dialog and JSON data will open in the BLOB-viewer. In the BLOB-viewer we have added validation that content is valid JSON. Also JSON-related keywords and functions are recognized in syntax highlighting and autocomplete. Also please see note at the bottom.
- SQLyog GUI now supports Foreign Key constraints between NDB tables for MySQL Cluster 7.3+.
- It is now possible to filter the users based on a string in the drop-down list in the ‘User Manager’. It is similar to filtering the tables, databases and connections, and an improvement to the filter in previous versions.
X-SQLyog Community 12.2.5 Rev 14
add to watchlist add to download basket send us an update REPORT- runs on:
-
Windows 8
Windows 7
Windows Vista
Windows XP - file size:
- 4.4 MB
- main category:
- Portable Software
- developer:
- visit homepage
4k Video Downloader
Zoom Client
calibre
Bitdefender Antivirus Free
Microsoft Teams
Context Menu Manager
IrfanView
ShareX
7-Zip
Windows Sandbox Launcher
- ShareX
- 7-Zip
- Windows Sandbox Launcher
- 4k Video Downloader
- Zoom Client
- calibre
- Bitdefender Antivirus Free
- Microsoft Teams
- Context Menu Manager
- IrfanView