How to Connect to MySQL Database in IntelliJ IDEA
In this video, I'd like to share with you how to work with MySQL databases inside IntelliJ IDEA using its Database tool, so you don't have to use any external tools like MySQL Workbench or MySQL Command Line Client.
In details, you will learn:
Define a datasource and Make connection to a MySQL database
Create a new table
Update data in a table
Execute SQL statements
Use SQL inspection suggestion in Java code
Suppose that you're using these software programs:
Java Development Kit (JDK)
IntelliJ IDEA Ultimate
MySQL Community server