Questions tagged as 'insert'

Tagged questions
0
answers

I inserted the time 3 hours ahead

I have a java.util.Date, which has a particular time (not the current one), and when I insert that Date in my database, it shows me the time 3 hours in advance, in the database I have a field DATETIME type that keeps the time, this is my code:...
asked by 28.10.2018 / 00:08
0
answers

Database in Mongodb, add information (Theft 3T)

I am working with mongodb, I have a collection of users, but it is empty, I want to add a user to the bd, I use Robo 3T, before I could do it quietly, I went Robo 3T, I connected, I went to the user collection and inserted a document, for exampl...
asked by 12.07.2018 / 13:43
0
answers

problems updating data with php and mysql

I am working with the loadata but mysql if you accept the "" but not php, so I decided to insert all the raw data (with loadata but using only varchar fields) in a table for later on those fields to do operations, my problem it is in the last co...
asked by 05.04.2018 / 03:17
2
answers

Duplicate value ERROR, but I need to identify the field

My question is very simple but I guess we are all here to support each other and keep learning. My problem is in this line of code: INSERT INTO DEPENDIENTES VALUES (78900456,'Oscar','M',15-01-89,'Hijo'); the error bounces me...
asked by 22.10.2017 / 21:55
0
answers

How can I upload data from a flat file (excel) to SQL server express?

I tried to upload a flat file (excel) in xlsx and csv formats but I get the following error:    Mens. 4864, Level 16, State 1, Line 1 Data conversion error   of mass loading (type not matching or character not valid for the   code page specif...
asked by 09.10.2017 / 15:35
0
answers

Avoid MySQL error # 1442 when inserting and executing a trigger

CREATE TRIGGER 'user_tel' AFTER INSERT ON 'usuarios' FOR EACH ROW TROW BEGIN DECLARE TEL CHAR(14); DECLARE ID INT; SET TEL = (SELECT telefono FROM usuarios ORDER BY idUsuario DESC LIMIT 1); SET ID = (SELECT idUsuario FROM usuarios ORDER BY i...
asked by 24.03.2018 / 05:40
2
answers

Where to initialize a BD SQLite on Android?

I have created a single row table where the only function will be to update some values. I just have to make an INSERT with default values that run the first time I do the following but without success. Where can I make this insert so that it...
asked by 21.04.2018 / 23:32
2
answers

Insert 'N' times of PHP AJAX MYSQL records

I was looking for a way to generate a list with information depending on 2 variables, I found an example ( Link ) and I found it interesting. The problem is that when inserting the selected data it inserts them into the Base de Datos as a...
asked by 24.07.2018 / 23:52
3
answers

Using Contains in SQL server

Hello friends I want to make an insert, but I will only do it if one of the parameters that my SP is receiving, in this case the extension has the word "pdf" , then I'm trying to do this, but send me error: s Insert into ArchivosCont...
asked by 03.09.2018 / 23:03
2
answers

Insert current date in a mysql table - php

I have a question about inserting the current date in a row into a mysql table in case there is no such record. Example: Insert 2017-10-10 in a row if it does not exist. But insert a new record in case it's another day like tomorrow (2017-10-11)...
asked by 10.10.2017 / 21:25