MySQL supports MD5() and some other cool functions that do the math for you and save the result in the table field, but what happens when you already have a database and the table in place and you are using “Navicat”, plus you don’t want to fiddle with raw SQL?

Luckily, Navicat has the so called “Raw Mode” when viewing a table’s rows which allows us to insert data using MySQL expressions/functions.

Here are the steps on how to insert a MD5()’ed password in a “users” table using Navicat:
1. Open your desired table with Navicat:

2. Choose “View->Raw Mode” from the top menu:

3. In your password field, type the expression, whose result you want inserted in that field, e.g.

MD5('newpassword')

4. Hit “Enter” and “Ctrl+S” to apply the changes. Optionally disable “Raw mode” from the menu if you need to go back to the regular mode.

Enjoy the result of the MD5, without using complex raw SQL queries that are prone to typos.

Leave a Reply

Your email address will not be published. Required fields are marked *