Using mysql with oracle sql developer

Question

I have configured mysql db with oracle sql developer version 4.0. But create table, create database all the options for mysql databases are disabled.

I was able to create a new database only by running the create database command. Can any tell me a workaround for this. Is it not possible to create tables using the GUI?

Screenshot attached.

enter image description here

Didn't you specify a database when we create a MySQL connection in SQL Developer? Can you not create tables in that database? — APC
– APC, Commented May 3, 2015 at 5:08
well there are several existing dbs, I need to create a new one, for that I can't do it via GUI. — techPackets
– techPackets, Commented May 3, 2015 at 5:08

thatjeffsmith · Accepted Answer · 2015-05-03 15:25:07Z

4

The MySQL support in Oracle SQL Developer is for migrating MySQL databases to Oracle.

If you want that type of GUI support, you should be using the MySQL Workbench product.

answered May 3, 2015 at 15:25

thatjeffsmith

22.7k6 gold badges44 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Skandix · Accepted Answer · 2019-03-11 12:06:22Z

0

it is possible to use Oracle SQL developer for MySQL DB.

All you need to do is to use following convension:

DB_name.TABLE_name
SELECT * FROM movies.directors
DB_name = movies
TABLE_name = directors

edited Mar 11, 2019 at 12:06

Skandix

2,0206 gold badges31 silver badges38 bronze badges

answered Mar 11, 2019 at 9:30

keviin077

1

Collectives™ on Stack Overflow

Using mysql with oracle sql developer

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related