Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Thursday, July 31, 2014
Using Oracle SQL Developer with MySQL database
I have been using the free Oracle SQL Developer as my main "alternative" to the text-based SQL Plus client for a while. I have used TOAD before. My co-w's favorite was Golden32. Even though I work with the database quite a bit, I am actually not too picky about what client to use. After all, there are times I have to get on to the database server itself and use SQL Plus. Any GUI is a luxury compared to that. Recently I needed to work on a MySQL database so I wonder if I could "re-use" SQL Developer. I didn't have high-hope to begin with (the alternative would have been the free MySQL Workbench from MySQL.) After all, it's from Oracle and might work with Oracle DB only. MySQL was acquired by Sun which was acquired by Oracle though. It turns out Oracle SQL Developer does work with MySQL (since 2007) I learned from this page that all it takes is opening Tools > Preferences > Databases and there is a third party JDBC driver. Simply add the MySQL Connector JAR. I also opened Help > Check for updates and get the MySQL related update. Not sure if it's really necessary. These links (1,2) did not mention this step.
Another MySQL tip I learned today was how to limit the number of rows it queries. In M$ SQL Server, you simply add TOP [N] after SELECT. For MySQL, it's adding LIMIT [N] at the end.
Subscribe to:
Posts (Atom)