This content has been marked as final. Show 11 replies
CrackerJack wrote:so why are you posting a mysql issue in an oracle forum?
I'm using sqldeveloper 3.1.07 and trying to some selects on a mysql 5.1 database.
SELECT SYSDATE(); works fine, but if I try to
select from database mysql;
---> and table user there is an error cause no database is selected.
How do I use sqldeveloper correctly for this task.
How/where do I run the mysql command with the sqldeveloper ?
Any help is appreciated.
no luck in that thread:(
You only posted two hours ago. This isn't a paid support service. The people that might help you are all around the world. Nothing is URGENT for us.
This is not the proper forum. Please mark the question ANSWERED and follow up in the sql developer forum.
Hi CrackerJack -
Don't know if it is the only or best way, but:
1. Right click on your connection and select properties.
2. In the properties dialog, MySQL tab, click the "Choose Database" button to populate the drop-down.
3. Select "mysql" and hit "Save", then "Connect".
In worksheet, you can now type your select statements. E.g.,
select * from db;
then hit green arrow [Run Statement (Ctrl+Enter)]
SQL Developer Team
Hi Cracker Jack,
SQL Developer parsers the text within a SQL Worksheet to identify each individual statement and its type.
At the moment SQL Developer only has an Oracle SQL, SQL*Plus , PL/SQL parser.
This means the worksheet only recognizes SQL which is similar to Oracle SQL (SELECT,INSERT,UPDATE,DELETE, .... ).
When connecting to MySQL or other non Oracle databases, the worksheet should work fine with standard SQL (like your select) , but when running a particular MySQL (or non Oracle) command , the worksheet doesn't know how to interpret it.
You can explicitly provide the information the SQL Worksheet needs by using a hint.
SQL Developer Team.