insert Questions
5
Solved
I'm trying to insert values into a Many2many or One2many relation table field in Odoo (former OpenERP). Do you have any idea how to do this?
Virg asked 21/2, 2012 at 12:11
3
Solved
There is a list, for example,
a=[1,2,3,4]
I can use
a.append(some_value)
to add element at the end of list, and
a.insert(exact_position, some_value)
to insert element on any other posit...
6
I am working on a large MySQL database and I need to improve INSERT performance on a specific table. This one contains about 200 Millions rows and its structure is as follows:
(a little premise: I...
Grizelda asked 3/8, 2013 at 12:50
4
Imagine I have a MySQL table (tbl_test) with these fields: id, title, priority.
id will be incremented automatically. I need to fill priority field with a value as same as id field after inserting....
Sweatt asked 12/3, 2014 at 5:37
5
Solved
Example:
create table foo(
id serial,
txt text
);
insert into foo(txt) values ('a'),('b'),('c') returning id;
Returns:
id
----
1
2
3
(3 rows)
It seems that the first id in the return...
Nava asked 25/3, 2011 at 23:52
5
Solved
I am trying to select data from one table
and insert the data into another table
SELECT ticker FROM tickerdb;
Using OracleSql I am trying to
get the ticker symbol "GOOG" from the tickerdb tab...
3
Solved
I get this exception when I try to insert a DBNull.Value into a nullable varbinary(max) field:
Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT functio...
Keister asked 10/7, 2012 at 10:58
8
Solved
3
Solved
One of the main reasons given for using auto-increment PK in MySQL is that it guarantees all inserts into the clustered PK index will be in order and hence fast. I understand that.
But what about ...
Lacielacing asked 28/3, 2011 at 21:22
3
I get a violation of primary key constraint error on a single record when I try to insert it to an existing table.
The first time the issue appeared was within a merge statement, but I can reprod...
Tarver asked 7/8, 2013 at 12:3
2
Solved
Main Question: What is the fastest way to insert an item into a list that is already sorted using Julia?
Currently, I do this:
v = [1, 2, 3, 5] #example list
x = 4 #value to insert
index = search...
12
Solved
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`purchase_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAUL...
5
Solved
I have a table, with types varchar, datetime, datetime:
NAME | START | END
Bob | 10/30 | 11/2
What's a SQL query can I look up to find out how to make that table be?:
NAME | START | END
Bob | 1...
Seamaid asked 15/12, 2014 at 17:23
7
Solved
I am trying to insert into my mySQL database. The first column is the 'id' column, since its an auto_increment field, I left it blank. For some reason, I am unable to insert and I am getting the er...
14
Solved
I'm passing a large dataset into a MySQL table via PHP using insert commands and I'm wondering if it's possible to insert approximately 1000 rows at a time via a query other than appending each val...
Cloistered asked 23/4, 2009 at 1:39
10
Solved
SQL Server question.
When doing
INSERT INTO T1 SELECT (C1, C2) FROM T2
I don't want to specify column names of T1 because they are the same as in T2
Is it possible to do so?
Currently I'm getting ...
Khalid asked 24/11, 2009 at 3:43
18
Solved
I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere due to pulling up tons of help docs and articles about "bulk imports".
Here's what I want to d...
Nikos asked 12/4, 2010 at 19:18
7
Solved
In JavaScript, I can use splice to insert an array of multiple elements in to an array: myArray.splice(insertIndex, removeNElements, ...insertThese).
But I can't seem to find a way to do something ...
5
Solved
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.
I've tried:
X = X.insert(X, 0)
how do I insert into X...
7
Can i use LIMIT 2 on MySQL INSERT query?
e.g.
INSERT INTO MyTable
(user_name,password)
VALUES
(john,366543),
(sam,654654)
LIMIT 2
I tried and its saying
`#1064 - You have an error in your ...
5
Solved
This is more of a theory question.
If I'm running 50,000 queries that insert new rows, and 50,000 queries that updates those rows, which one will take less time?
Bream asked 14/7, 2010 at 22:58
6
Solved
PizzaChange=float(input("What would you like the new price for all standard pizzas to be? "))
PriceList[0][1][2][3][4][5][6]=[PizzaChange]
PriceList[7][8][9][10][11]=[PizzaChange+3]
Ba...
3
Solved
In PHP, I am using PDO with the pgSQL drivers. I wanted to know how to get the value of the "RETURNING" clause given in the INSERT sql query.
My current code looks like this,
$query = 'INSERT INTO...
Limitation asked 26/1, 2010 at 18:12
3
Solved
I've been trying to figure out which one to use when, and if I should even use both.
Been looking at Laravel docs and they have both in there. From what I can make out of it, DB::insert() provides...
7
Solved
I am just creating a simple ToDo App in Flutter. I am managing all the todo tasks on the list. I want to add any new todo tasks at the beginning of the list. I am able to use this workaround kind o...
© 2022 - 2024 — McMap. All rights reserved.