Ability to copy the written query

If you run MySQL on your local machine, using Wamp or Mamp etc., you can enable the query log. Then you can copy/paste the actual queries which are executed. It’s great for debugging. You can also set this up directly in Wappler, but I don’t know how to do this on a Mac.

To enable the query log in Windows, add/modify this part of my.ini:
[mysqld]
port = 3306
; enables SQL queries to be logged
general_log = on
general_log_file=C:\wamp64\logs\mysql_query.log

I expect it’s similar on a Mac.

2 Likes