Similarly, you can rename a table as easily as renaming a file. Excellent for making a backup before testing some new code. Just right-click on any table and choose “Duplicate Table” and you instantly have a copy of it right there in the database. One feature we find ourselves using is the Duplicate Table function. Make your changes right there, again without having to pull up additional forms, and save your changes. Similarly, if you need to change the structure of a table, select the table and click on “Design Table” to bring the table up in Design mode. This is so much easier and faster than having to click an Edit icon by a record to then pull up a new form. If you need to change some field values, just make the change right there and move to a different record to commit the change. Scroll through or page through the records to get to the one you’re looking for. If the table is small and you’re looking for a specific record, sort on any one or more fields by selecting it, and clicking one button. Review and modify data quickly and easily – Just double-click on a table to open it up in Browse mode. The login information is set up in the connection, so getting to the data is fast-no time taken up with tedious logins. To open one up, we just click it to see a list of all the tables. Simple, fast, and intuitive access to all of your databases from the desktop – Connections to all of the databases we manage are listed right there on the left hand side. We’ve been using Navicat almost exclusively since 2004.
What is as good as navicat for mysql series#
It is simply the first of a series of reviews of products and services we use or have tried at Web Site Optimizers. We did not consult with Navicat in any way in writing this. To be clear, this is not a paid endorsement or advertorial. To do that, we turn to Navicat by PremiumSoft. At Web Site Optimizers, our development team must maintain a large number of MySQL databases. And if so, you want a tool that can give you these abilities easily and powerfully. Whether you develop and maintain a large number of custom built web sites, or if you just need to perform some specific queries on the database for your lone site, there is a good chance you need to access, manage, and/or query a MySQL database.