Questions tagged as 'insert'

Tagged questions
2
answers

SQL 60,000 records in less than 3 minutes

Today I have an optimization question, my boss wants me to save 60,000 records in the shortest possible time. For this I have made a query that takes information from a .csv file and I put it on a temporary basis, from which I make a small fil...
asked by 23.08.2018 / 19:38
2
answers

Insert an array in one position within another

I'm doing an exercise of POO but with pointers, and I have to insert an array into another in the position that is requested, without overwriting or losing those that are, just move it. In the function void IntArr::addElement(int po...
asked by 18.04.2018 / 20:00
2
answers

how to make an INSERT of several countries

This situation has never occurred to me but there is always a first time. The thing is that I have a field type select and I need to fill it with a list of countries, I already have the list but I have no idea how to do INSERT of this...
asked by 16.09.2018 / 01:26
1
answer

because it works when importing cv2 and cv does not work when I import it

I'm trying this import numpy as np import cv2 #Cargar los dos videos video1 = cv2.VideoCapture('video1.mov') video2 = cv2.VideoCapture('video2.mov') #Guardar las dimensiones del primer video ancho1 = int(video1.get(cv2.cv.CV_CAP_PROP_FRAME_W...
asked by 10.07.2017 / 01:24
1
answer

Run 3 queries in JAVA

I want to make 3 queries within a method in JAVA in order to assign a serial number to my record that has the ID number as consecutive, this is my code. public void guardar() { String erp = jComboBox1.getSelectedItem().toString(); String...
asked by 13.09.2018 / 01:44
1
answer

Replace into MySql problem with foreign key

I'm doing an insert in mysql and searching the internet I found the replace into that if the record exists it deletes it and enters the new one, now try it in mysql and it gave me a foreign key error since the registry is associated to another t...
asked by 21.10.2018 / 20:33
2
answers

Passing data from a table in HTML to an insert in Mysql with PHP

I hope you can help me. What happens is that I have a table in HTML that I am generating with javascript, but the result that it gives me, I must save it in a table that I have in my BD HTML Table: I already tried going through th...
asked by 14.08.2018 / 22:13
1
answer

Avoid inserting into a table using PHP / SQL if this record already exists

When I precede in my " Submit " I execute an insert " Insert " that saves a series of records " X[i+] ": id,_Nombre,__fecha a id,_Nombre,__fecha 1__Juan_____22/12/2000 2__Fulano___22/12/2000 3__Aldo_____22/12/2000 I wish that if...
asked by 19.07.2018 / 17:13
1
answer

How to save an image of any format in Python?

I have been investigating the way to save an image in python but so far I have not found anything that can be useful, what I need is to know that import have and how to save the image in python, this image will keep it in a database in mo...
asked by 07.08.2017 / 19:17
3
answers

In MySQL I get error 1242. For Delete and Insert Into

I have a Sales table that is very much related to many with a table Products For that reason, create the table DetailofProductsEnLaSale CREATE TABLE IF NOT EXISTS DetalleDeLosProductosEnLaVenta ( ID_Productos INT NOT NULL, ID_Venta...
asked by 13.09.2017 / 19:51