Sql in intellij

已回答

Hello,

I work on a sql file in intellij and in this .sql file i create many table like this :

CREATE TABLE chercheur (
numc INTEGER,
nom VARCHAR (20) NOT NULL ,
prenom VARCHAR (20) NOT NULL,
equipe VARCHAR (20) NOT NULL,
CONSTRAINT pk_chercheur PRIMARY KEY (numc)
);

I add tupple :

INSERT INTO chercheur VALUES (3, 'Duvivier', 'Anne', 'BD');
INSERT INTO chercheur VALUES (4, 'Rifflet', 'Jean-Francois', 'Systeme');

And i do request : 

SELECT DISTINCT nomorg
FROM chercheur c JOIN mission m ON c.numc = m.numc
JOIN visite v on m.numis = v.numis
WHERE nom = 'Roitelet' AND prenom = 'Martine';

How can I see graphically these requests, creation table, ...  like iSQL for example (when I try to run this .sql intellij talk me about dataBase but i don't understand.)

0

Hello Emerick,

The database management functionality in IntelliJ IDEA is supported by the 'Database tools and SQL' plugin. The plugin provides support for all features available in DataGrip, a standalone database management environment from JetBrains for developers.

With this plugin, you can query, create and manage databases. Databases can work locally, on a server, or in the cloud. The plugin supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and others. Plugin is available in the Ultimate version of IntelliJ IDEA only.

If you are using the Ultimate version, feel free to get yourself acquainted with the documentation on how to set up and use the database tools in IDEA.

0

请先登录再写评论。