Top "Insert" questions

MySQL: Insert datetime into other datetime field

I have a table with a DATETIME column. I would like to SELECT this datetime value and INSERT it into …

mysql sql datetime insert

How to insert an item into a key/value pair object?

Ok...here's a softball question... I just need to be able to insert a key/value pair into an object …

c# insert list

Insert and set value with max()+1 problems

I am trying to insert a new row and set the customer_id with max()+1. The reason for this is …

mysql sql insert mysql-error-1093

How can I insert values into a table, using a subquery with more than one result?

I really would appreciate your help. Probably it's a quite simple problem to solve - but I'm not the one .. ;…

sql insert subquery

SQL - IF EXISTS UPDATE ELSE INSERT INTO

What I'm trying to do is INSERT subscribers in my database, but IF EXISTS it should UPDATE the row, ELSE …

mysql sql insert exists

insert data from one table to another in mysql

i want to read all data from one table and insert some data in to another table. my query is …

mysql insert

PDO Prepared Inserts multiple rows in single query

I am currently using this type of SQL on MySQL to insert multiple rows of values in one single query: …

php pdo insert prepared-statement

How to insert default values in SQL table?

I have a table like this: create table1 (field1 int, field2 int default 5557, field3 int default 1337, field4 int default 1337) I …

tsql insert default

MySQL INSERT INTO ... VALUES and SELECT

Is there a way to insert pre-set values and values I get from a select-query? For example: INSERT INTO table1 …

mysql sql select insert

In STL maps, is it better to use map::insert than []?

A while ago, I had a discussion with a colleague about how to insert values in STL maps. I preferred …

c++ dictionary stl insert stdmap