Top "Insert" questions

INSERT INTO with SubQuery MySQL

I have this Statement: INSERT INTO qa_costpriceslog (item_code, invoice_code, item_costprice) VALUES (1, 2, (SELECT item_costprice FROM qa_…

mysql insert subquery

Copy rows from one table onto another using INSERT query

I have a table with 158 columns and 22,000 rows and I have another empty table where I want insert values dynamically …

mysql select insert records

What is an efficient way of inserting thousands of records into an SQLite table using Django?

I have to insert 8000+ records into a SQLite database using Django's ORM. This operation needs to be run as a …

python sql django sqlite insert

Prepend element to numpy array

I have the following numpy array import numpy as np X = np.array([[5.], [4.], [3.], [2.], [1.]]) I want to insert [6.] at the beginning. …

python numpy insert

Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

I know that you can use ON DUPLICATE KEY UPDATE to update a certain value if there is a record …

mysql insert on-duplicate-key

Matlab - insert/append rows into matrix iteratively

How in matlab I can interactively append matrix with rows? For example lets say I have empty matrix: m = []; and …

matlab for-loop matrix insert rows

PL/SQL Inserting 1 row for each result in a select

I am writing a PL/SQL Procedure that performs a select based on input variables and then inserts a row …

plsql for-loop insert procedure

Incorrect Integer (2147483647) is inserted into MySQL?

Alright, so I've been toying around with the Steam Web API, I have one of the values stored in a …

php mysql insert steam-web-api

SQL Populate table with random data

I have a table with two fields: id(UUID) that is primary Key and description (var255) I want to insert …

sql postgresql insert

How to add a character at a particular index in string in Swift

I have a string like this in Swift: var stringts:String = "3022513240" If I want to change it to string to …

ios string swift insert