Top "Sql-insert" questions

Node.js and Oracle DB: Insert statement doesn't work

I have a problem according to SQL query. My insert query returns answer that tuple is inserted successfully but actually …

node.js oracle sql-insert node-oracledb

Insert values statement can contain only constant literal values or variable references in SQL Data Warehouse

Consider this table: CREATE TABLE t (i int, j int, ...); I want to insert data into a table from a …

sql azure tsql sql-insert azure-sqldw

How to determine which column is implicated in "value too long for type character varying"?

I'm programatically adding data to a PostgreSQL table using Python and psycopg - this is working fine. Occasionally though, a …

postgresql sql-insert

One INSERT with multiple SELECT

I've already read this, this and this, but I cant make this SQL work: INSERT INTO main_phrase (description) VALUES (…

postgresql many-to-many sql-insert common-table-expression sql-returning

Postgres with Java I can't insert data

I tried to make an insert to my postgres database with Java. I have default configuration for my local database. …

java postgresql sql-insert quoted-identifier