Associating New SQL button with correct database
Posted: Fri 13 May 2011 21:19
I am plowing through the tutorials and came to the place where I was to add data to a existing database. I have created the database 'demobase' and the two tables 'dep' and 'emp' and can enter data into them using the grid-based editor. This works fine. What doesn't work is entering data using a query.
When I press the 'New SQL' button on the Main Standard toolbar it opens a SQL1.sql window but to the wrong database. It opens it to the information_schema that is first on the list in the Database Explorer.
How do I manage to open a New SQL on the correct database?
Possible problem - I have a bad entry in the Database Explorer tree that I cannot delete. Its right between the information_schema database and the one that I want to open (demobase). Trying to drop the bad entry produces this:
Error dropping database (can't rmdir '.\sakila-db\,errno:17)
Is this causing the problem?
Fix?
When I press the 'New SQL' button on the Main Standard toolbar it opens a SQL1.sql window but to the wrong database. It opens it to the information_schema that is first on the list in the Database Explorer.
How do I manage to open a New SQL on the correct database?
Possible problem - I have a bad entry in the Database Explorer tree that I cannot delete. Its right between the information_schema database and the one that I want to open (demobase). Trying to drop the bad entry produces this:
Error dropping database (can't rmdir '.\sakila-db\,errno:17)
Is this causing the problem?
Fix?