I am kite, the official number “ancient kite”. Articles will be included in JavaNewBee, and there will be a Java back-end knowledge map, which will cover the path from small white to big cow.
No harm, today is just to recommend you some MySQL clients, these clients have one thing in common, that is, easy to use and free.
“Harm, I think is also plain!” Then, turn around and download it.
Which do the development around the database, in terms of relational data, use the most is MySQL, Oracle, Microsoft SQL Server, Oracle is good to use but pay, Microsoft SQL Server pay and somebody else’s own client is very good to use, The rest of MySQL is free to use, but the client side is pretty boring.
Navicat is the most useful client for MySQL, but Navicat is not free. It is quite expensive and unnecessary for individual developers.
Of course, there are free versions of everything on the Internet, and you may not believe yourself if you say you’ve never used version XX. In private use it is nothing, but which day meet with the legitimate player, also really a little embarrassed to take.
Don’t panic, here are a few legitimate and free MySQL clients to make sure you get your hands on them.
MySQL WorkBench
MySQL WorkBench is an official client that supports Mac, Windows and Linux. Because it is the official product, so the function is more complete. I used to work in.NET development. At that time, I worked with Microsoft SQL Server every day, so I am very familiar with the interface style of MySQL WorkBench, which is very similar to Microsoft SQL Server. Even the style of Visual Studio is similar to that of the first IDE in the universe. So, I suspect it borrows from Microsoft’s style.
Style does not matter, it is important to use.
Let’s just say you’ve used Navicat, right? Navicat has all the features.
-
Support database structure management, including database, table structure, data management;
-
Support ER model management, including forward and reverse engineering;
-
Support visual effects dashboard;
image-20200707101718124
-
Support data migration, such as migrating from Microsoft SQL Server to MySQL;
Website address: https://www.mysql.com/products/workbench/
Sequel Pro
Mac only, but the function is relatively complete.
Supports database management. You can add and modify the database. Table structure, content, and association can be managed on the GUI.
There are two more handy operations that list all the Server Variables.
Server Processes can be listed
Official website: http://sequelpro.com/
Beekeeper Studio
Mac, Windows, Linux, but the function is relatively simple. Support not only MySQL, but also other databases.
Dark style, very high.
However, it only supports SQL statements and does not support complex management.
Queries can be saved and history records can be automatically recorded.
Website address: https://www.beekeeperstudio.io/
HeidiSQL
Only Windows is supported. The function is quite complete. Support structure management and data content management.
Website address: https://www.heidisql.com/
DBeaver
The community edition is free, but supports mainstream relational databases, including Hive. The Professional edition supports non-relational databases as well as relational databases. Mac, Windows, Linux, and Eclipse plug-ins are also available.
Official website: https://dbeaver.io/
The last
In the end, the big guy chose the command line.
Public account “ancient kite”, Java developer, full stack engineer, known as late prince, bug killer, good at solving problems. A programmer with both depth and breadth of encouragement teacher, originally intended to write poetry but wrote up the code of rural code farmers! Adhere to the original dry goods output, so far there are more than 80 original articles, you can choose to pay attention to me now, or look at the historical articles and then pay attention to it. Long press the QR code to follow, become excellent with me!
