Questions tagged as 'insert'

Tagged questions
2
answers

Use "WHERE" as a subquery with INSERT

My idea is to be able to insert the sum between 2018-07-12 and 9 days ( SELECT "" + interval 9 day) ) in the column fechaFin of the same table. But first I want to identify a row of T_tarifa with where but it...
asked by 21.03.2018 / 21:29
1
answer

Any way to insert records when the table has default and identity in SQL Server?

CREATE PROCEDURE USP_ADD_CLIENTE @PNIDTIPDOCUMENTO INT, @PSNUMDOCUMENTO VARCHAR(35), @PSNOMBRES VARCHAR(40), @PSAPEPAT VARCHAR(25), @PSAPEMAT VARCHAR(25), @PSCORREO VARCHAR(40), @PSTELEF VARCHAR(25), @PNESTADO INT, @PSUSUREG VARCHAR(40) AS IN...
asked by 06.11.2017 / 19:16
1
answer

Save result of Array in Mysql

with help I have used the following code that allows me to enter data from an input and that it be separated into 3 different values that I need, which are value, code and serial <?php $datos = "3,5 1401 4145 7854 8454 7458 5152556555 5 140...
asked by 21.09.2018 / 14:18
1
answer

How to fill a column with data from the column of 2 other tables?

I have the following tables: TABLE A: ID NOMBRE 1 A 2 B 3 C and TABLE B : ID NOMBRE 1 D 2 E and I want to insert the data from the "name" columns of both tables in the "name" column of a third table ( TABLE C...
asked by 08.05.2018 / 22:39
1
answer

Insert data in two different tables with MVC

I have two tables that are related, one of them depends on the information of the 1st table (payments depend on contracts). I just have to take a form to save the information. This is how I have the registry function in the Controller: publ...
asked by 26.02.2018 / 09:30
2
answers

How to add several records at once with php and javascript

I have knowledge in CRUD (Create, Read, Update and Delete) of MySQL PHP but in a last project of warehouse I wanted to make a form that the more inputs are requested, more rows of form can be added, but this I do not know how to add a id...
asked by 31.01.2018 / 04:24
1
answer

Insert in Mysql does not execute

When I want to insert information into my database, it does not run: $sql_in = "INSERT INTO solicitudes(codsol, nro, fechacrea, rutus, banco, tipocuenta, nrocuenta, actividad, lugar, fechaact, proveedor, rutprov, factura, rex, listado, ordenco...
asked by 16.11.2017 / 10:00
2
answers

Insert data in MySQL mediating form and PHP

Good afternoon, I am trying to do an exercise that consists of a bus manager, trying to register new buses through a form. I attached the code and my doubts to see if you can help me: The form where the data is entered: <form action="fun...
asked by 09.11.2017 / 19:49
1
answer

Insert in SQL fields not null

Hi, I have the following question. It's something very basic but now it has me stranded. I want to make a query to a table from sql server managment. The problem is that I have the Id that turns out to be primary key, not null and it is self-inc...
asked by 18.10.2017 / 21:30
1
answer

Mongodb: Compare two collections and eliminate repeated documents

I work in a company that makes the collection service to bank customers (banks are our clients) and I mention this so that I do not think I do it for non-legal purposes. What is the best mechanism to eliminate existing data in another collect...
asked by 03.10.2017 / 01:00