I get this error whern I try to run this sql in the Data Source Plugin "No Database Selected" I tried running the sql from the context in my application and I got nothing as well.
Run "use <database-name>" statement before any other queries. Otherwise change database URL to include <database-name> so it will be "used" by default.
Run "use <database-name>" statement before any other queries.
Otherwise change database URL to include <database-name> so it will be "used" by default.
OK thank you that fixed it, I should have thought of that first
thanks again
I have the same problem and I tried putting the URL to include the name but it doesn't work it gives me the error [3D000] [1046]
And if i try running USE it says unknown database
Just go inside Database Tool Window and write the name of your database as in the picture below and after click on apply. It should work