Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question appears to be off-topic because it lacks sufficient information to diagnose the problem. Describe your problem in more detail or include a minimal example in the question itself. Closed 8 years ago. Improve this question How can I … Read more
A while ago, I had a discussion with a colleague about how to insert values in STL maps. I preferred map[key] = value; because it feels natural and is clear to read whereas he preferred map.insert(std::make_pair(key, value)). I just asked him and neither of us can remember the reason why insert is better, but I … Read more
I am trying to optimize one part of my code that inserts data into MySQL. Should I chain INSERTs to make one huge multiple-row INSERT or are multiple separate INSERTs faster? 13 Answers 13
This question already has answers here: How can I prevent SQL injection in PHP? (28 answers) Closed 6 years ago. I have a perplexing issue that I can’t seem to comprehend… I have two SQL statements: The first enters information from a form into the database. The second takes data from the database entered above, … Read more
I’m using maps for the first time and I realized that there are many ways to insert an element. You can use emplace(), operator[] or insert(), plus variants like using value_type or make_pair. While there is a lot of information about all of them and questions about particular cases, I still can’t understand the big … Read more
I have a database schema named: nyummy and a table named cimory: create table nyummy.cimory ( id numeric(10,0) not null, name character varying(60) not null, city character varying(50) not null, CONSTRAINT cimory_pkey PRIMARY KEY (id) ); I want to export the cimory table’s data as insert SQL script file. However, I only want to export … Read more
If I have an insert statement such as: INSERT INTO MyTable ( Name, Address, PhoneNo ) VALUES ( ‘Yatrix’, ‘1234 Address Stuff’, ‘1112223333’ ) How do I set @var INT to the new row’s identity value (called Id) using the OUTPUT clause? I’ve seen samples of putting INSERTED.Name into table variables, for example, but I … Read more
In MySQL I am trying to copy a row with an autoincrement column ID=1 and insert the data into same table as a new row with column ID=2. How can I do this in a single query? 16 Answers 16
I’ve found a few “would be” solutions for the classic “How do I insert a new record or update one if it already exists” but I cannot get any of them to work in SQLite. I have a table defined as follows: CREATE TABLE Book ID INTEGER PRIMARY KEY AUTOINCREMENT, Name VARCHAR(60) UNIQUE, TypeID INTEGER, … Read more
Let’s say I am doing a MySQL INSERT into one of my tables and the table has the column item_id which is set to autoincrement and primary key. How do I get the query to output the value of the newly generated primary key item_id in the same query? Currently I am running a second … Read more