SQL DEVELOPER: WORK WITH DRIVER JDBC MYSQL

User_V7BJL

Good morning to the whole community. I read in a 2016 post that it is not possible to make changes with SQL DEVELOPER to databases in MYSQL. I wanted to know if after 5 years the situation has changed or has remained the same. Personally I tried to install the jdbc driver (downloaded from the official site from the following link: https://dev.mysql.com/downloads/connector/j/) but I can perform read-only operations.

Do I have any alternatives or do I have to give up?

thatJeffSmith-Oracle

i just created a database (schema), so it's not read-only

User_V7BJL

I have no problem connecting to the database.

However, if I try to operate on the records, I am unable to add or delete or insert records.

I can't even filter the records or sort.

thatJeffSmith-Oracle

you'll need to issue an INSERT/UPDATE/DELETE/MERGE/etc via DML in the SQL worksheet and run it through the editor

User_V7BJL

unfortunately it is very uncomfortable :-( I would have preferred to use the toolbar as I do for an oracle database :-(

thatJeffSmith-Oracle

you should be using the MySQL Workbench for everyday usage of MySQL Database.

SQL Developer is here to help you migrate your MySQL Database to Oracle, and that's the only reason we allow for MySQL database connections.

User_V7BJL

Thanks for all! 😀