Top "Sql-insert" questions

Insert operation disallowed on virtual columns

I dont understand the below issue where i am trying to insert the query and getting error as Insert operation …

oracle sql-insert virtual-column

How does COPY work and why is it so much faster than INSERT?

Today I spent my day improving the performance of my Python script which pushes data into my Postgres database. I …

python postgresql sql-insert postgresql-copy

PostgreSQL INSERT into an array of enums

How can I insert an array of enums? Here is my enum: CREATE TYPE equipment AS ENUM ('projector','PAsystem','safe',…

postgresql types enums sql-insert

Fastest way to update a MySQL table if row exists else insert. More than 2 non-unique keys

I have the following table structure: CREATE TABLE IF NOT EXISTS `reports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` int(11) …

php mysql sql sql-update sql-insert

What is the best way to insert multiple rows in PHP PDO MYSQL?

Say, we have multiple rows to be inserted in a table: $rows = [(1,2,3), (4,5,6), (7,8,9) ... ] //[ array of values ]; Using PDO: $sql = "insert into `…

php mysql pdo sql-insert

Equivalent of ON CONFLICT DO NOTHING for UPDATE postgres

I want to update rows in my postgres database if the updated version wouldn't violate the primary key constraint. If …

sql postgresql sql-update sql-insert where-clause

Is there a non-commercial alternative to Z.EntityFramework.Extensions?

Entity Framework can be very slow on mass insert/update/delete operations. Even the often suggested tweaks to turn off …

c# sql-update entity-framework-6 sql-insert sql-delete

INSERT-OUTPUT including column from other table

I have a stored procedure that needs to insert into three different tables, but I need to get the ID …

sql sql-server tsql sql-insert

Return id if a row exists, INSERT otherwise

I'm writing a function in node.js to query a PostgreSQL table. If the row exists, I want to return …

sql node.js postgresql sql-insert

How to use WITH CLAUSE ...INSERT query in SAP HANA?

Here I used With AS Clause.if i use SELECT query it is working fine but if i use insert …

sql sql-insert common-table-expression hana