| mysql selects with sqldeveloper [message #534849] |
Fri, 09 December 2011 11:16  |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
I'm using sqldeveloper 3 and like to use the sql-worksheet for some select on a mysql 5 database.
works fine, but if I try to select from database mysql and table user there is an error cause no database is selected.
The command
ends also with error unknown command.
How do I use sqldeveloper correctly for this task.
How/where do I run the mysql command
with the sqldeveloper ?
|
|
|
|
|
|
| Re: mysql selects with sqldeveloper [message #534930 is a reply to message #534928] |
Sat, 10 December 2011 06:59  |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
Yes i did configure sqldeveloper correctly, otherwise i couldn't connect to mysql, I mentioned that the select sysdate() works correctly, I can browse through the tables even through table user which is part of the database mysql,
but i cannot (or lets say I dont know how ) change database ( use mysql ; this is the standard database which contains the description of the complete mysql database; ) which you would normally do first if you try to select a table from the database mysql in the "mysql-shell". So my problem is to settle some command ( whcih work in the "mysql-shell" like status or use that_database and so on
|
|
|
|
|
|
| Re: mysql selects with sqldeveloper [message #534936 is a reply to message #534931] |
Sat, 10 December 2011 08:37 |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
Littlefoot,
Quote:
Maybe some commands (that work just nice in "mysql-shell") won't work in SQL Developer (just like, for example, some SQL*Plus commands don't work in SQL Developer either).
that's what I thought of too, but I do not know sqldeveloper very well, so I asked here.
Nevertheless, if choosing your actual database is not possible ( with use my_actual_database or somehow else), doing some select with the sqldeveloper is not possible, just browsing graphically through the objects....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
