Top "Insert" questions

Insert is an action to add information to a larger container that the information should reside within.

Inserting multiple rows into a SQL Server table using a table variable

I am currently using SQL Server 2008, and I am trying to create a statement using a table variable to insert …

sql sql-server-2008 insert table-variable
Can't perform Create, Update or Delete operations on Table because it has no primary key

I've been trying to insert row in the table having an identity column RequestID (which is primary key as well) …

linq insert identity
Using Mysql to do multiple INSERT on linked tables

I have two tables, one linked to the Primary Key of the other. At the moment I INSERT into table …

mysql stored-procedures insert last-insert-id
Why are 2 rows affected in my `INSERT ... ON DUPLICATE KEY UPDATE`?

I'm doing an INSERT ... ON DUPLICATE KEY UPDATE for a PRIMARY KEY in the following table: DESCRIBE users_interests; +------------+…

mysql insert insert-update
What is the difference between unordered_map::emplace and unordered_map::insert in C++?

What is the difference between std::unordered_map::emplace and std::unordered_map::insert in C++?

c++ c++11 insert unordered-map emplace
This PDO prepared statement returns false but does not throw an error

This code does not throw an error but the query fails, that is, the execute method returns false. How could …

php mysql insert pdo prepared-statement
No video with supported format and MIME type found in Firefox with HTML5 video

I'm trying to insert a video, using HTML5. I have the following markup: <video id="video" loop="" controls="" preload=""&…

video insert dreamweaver
python + pymongo: how to insert a new field on an existing document in mongo from a for loop

I'm using a for loop in python to loop over the result of a query with pymongo. Here is the …

python mongodb insert pymongo
ExecuteNonQuery() for Insert

Can you please tell me what's wrong with this code? Do I need to use DataAdapter to insert into a …

vb.net visual-studio sql-server-2008 insert executenonquery
SQLite insert speed slows as number of records increases due to an index

Original question Background It is well-known that SQLite needs to be fine tuned to achieve insert speeds on the order …

database optimization sqlite insert