Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 months ago. Improve this question I’m trying to sum the values of two columns into a new one, its for analysis purpose …
Tag: datagrip
What is the syntax error in this simple SQL query for creating a table?
I am trying out IntelliJ’s DataGrip to do some SQL work on a MariaDB database. Somehow i cannot execute the query that was automatically created by DataGrip itself…. Can you help me find the error in it ? The error is I tried to validate the query with an online validator and it seems fine… …
Query BETWEEN TWO TABLES OUTPUT (MYSQL)
two table EMPLOYEE and Department EMPLOYEE’s fields are ID,Name, Salary ,DEPT_ID(foreign key to department table) DEPARTMENT’S fields are id,NAME,LOCATION VALUES OF EMPLOYEE TABLE WILL Be Values OF DEPARTMENT TABLE WILL BE Output from these table should be DEPARTMENT_Name should be alpabetically w…
How to insert data with custom enum type from a csv into an existing PostgreSQL table
I want to insert data from a csv file into an existing table on a PostgreSQL database – let’s call the table automobile. One of my field is a custom enum – let’s call it brand. When I try to import records from a csv file with DataGrip built-in feature I got an error message: Yet in th…
Can’t commit changes to table with Datagrip
I use Datagrip 2016.3. When I try to alter a value in a table, I can’t commit that to the database (a Oracle SQL-DB). What did I do: – Setting a cell to /some new value – Pressing the checkmark icon (…