Top "Insert" questions

Generate insert SQL statements from a CSV file

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools …

sql csv insert firebird

Bulk/batch update/upsert in PostgreSQL

I'm writing a Django-ORM enchancement that attempts to cache models and postpone model saving until the end of the transaction. …

sql database postgresql insert sql-update

MySQL: Creating a new table with information from a query

In MySQL, I would like to create a new table with all the information in this query: select * into consultaa2 …

mysql sql insert sql-update

MySQL Conditional Insert

I am having a difficult time forming a conditional INSERT I have x_table with columns (instance, user, item) where …

mysql insert conditional

Grant Select, Insert, Update to a Tablespace

I've got a lot of tables in a tablespace, nearly 100. I have to grant Select, Insert, Update privileges on all …

oracle select insert grant tablespace

single quotes escape during string insertion into a database

Insertion fails when "'" is used. example string is: He's is a boy. I've attempted to skip the "'" using …

c# database insert special-characters

insert vs emplace vs operator[] in c++ map

I'm using maps for the first time and I realized that there are many ways to insert an element. You …

c++ dictionary insert operators emplace

PostgreSql INSERT FROM SELECT RETURNING ID

In PostgreSql 9.2.4 I have two tables: user (id, login, password, name) and dealer (id, user_id). And I want to …

sql postgresql insert postgresql-9.2

MySQL INSERT IF (custom if statements)

First, here's the concise summary of the question: Is it possible to run an INSERT statement conditionally? Something akin to …

mysql concurrency insert if-statement race-condition

"Unknown column in 'field list'", but column does exist

DROP TABLE IF EXISTS `transactions`; CREATE TABLE `transactions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `purchase_date` datetime DEFAULT NULL, …

mysql sql insert innodb