Explorer SQL

Post your questions and problem reports here

Moderator: kfury77

Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.
  • Check the Support section of the corresponding product first. Chances are you will find your answer there;
  • Do not create new topics for already reported problems. Add your comments to the existing topics instead;
  • Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
  • Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
  • Include the version number of the software you are using;
  • This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;
Post Reply
Domdom
Posts: 19
Joined: Tue Nov 01, 2016 10:12 am

Explorer SQL

Post by Domdom »

Is it really useful to state the name of the database in the parameterization of the SQL explorer ?

Because I have always access to all the basics of my connection. And therefore have to choose my database.

I thought instantly win one click with this option. :)
User avatar
Aivars
Blumentals Software Developer
Posts: 2462
Joined: Thu Aug 22, 2002 1:40 pm
Location: Latvia

Re: Explorer SQL

Post by Aivars »

It specifies the default database, e.g., if you connect to MySQL, launch SQL Browser and execute "SELECT * FROM mytable" then it will use mytable from the database that you specified in the connection parameters.
This parameter is even more important for SQLite, because it specifies the physical DB file and the connection is useless without it.
Blumentals Software Programmer
Domdom
Posts: 19
Joined: Tue Nov 01, 2016 10:12 am

Re: Explorer SQL

Post by Domdom »

Ok. Thanks Aivars for the explanation.
Post Reply