Questions tagged as 'sql-insert'

Tagged questions
1
answer

Problem when inserting into a SQLITE table using RAD STUDIO XE6

Good afternoon, I am having a problem in my code, I use Rad Studio XE6 connected to an SQLITE base, when I insert values with point in the table the following error occurs for example = 'near' 6.75 ": syntax error 'being 6.75 the value, when I p...
asked by 09.09.2014 / 20:43
0
answers

Problems with insert in Oracle with Laravel [closed]

I'm having a problem with a INSERT in Oracle using the yajra / laravel-oci8 package, where I get the following error:    Error Code: 1722 Error Message: ORA-01722: invalid number Position   : 260 Statement: insert into TRANSMISSAOITB...
asked by 20.06.2014 / 20:43
1
answer

Error in sql-insert command when passing variable as parameter (python 3)

I am trying to pass my "table" variable to the mysql command, however it is returning an error (from sql) during execution. What am I missing? Here I created the variable table table = input ('Table name:') while(tabela not in tabelasCad...
asked by 28.09.2017 / 21:53
1
answer

Receive variable value and insert multiple rows in MYSQL

I have the following variable: $ids = "758,749"; The table has the columns: id, provider_id, accept. When running a PHP script, I would like it to do something like this: INSERT INTO tabela (id, id_prestador, aceite) VALUES (null, $idd...
asked by 09.08.2017 / 18:22
3
answers

INSERT command error in Visual Studio

I have a web application in visual studio where I am getting the following message whenever I try to give an insert command    System.Data.SqlClient.SqlException: 'An explicit value for the identity column in table' C # code: SqlDataSou...
asked by 17.11.2017 / 17:52
2
answers

Perform insert into C # List [closed]

Can one give an example of how an sql insert would be in a list in C #?     
asked by 28.07.2016 / 03:00
1
answer

FUNCTION INSERT PHP

I'm trying to insert into DB when and it is in the following condition: public function cadastrar_agendamento($dados){ $consulta = $this->db->query(' SELECT cod_lab, cod_data, cod_horario, cod_assento, al_reg, dataagendamento...
asked by 17.10.2016 / 18:49
2
answers

INSERT CONCATENATE PHP MYSQL

I want to insert a record in mysql, according to the id already has something predefined example I will insert a post with the category with id = 2, so the name of my post will be something that I have already defined the rest of the past...
asked by 18.07.2016 / 05:57
1
answer

Add Letter in a field with 20000 lines

I have a produto table filled with 20000 products and I need to add a o in the first character of the codigo field of all rows. How can I do this with MySQL?     
asked by 07.04.2015 / 12:07
1
answer

(MySql) Insert or Update in the database

I need to perform a Insert in the database if there is no person's cpf. if it exists it has to do a Update . But all this through a single script in MySql . I have illustrated the example below as I am doing today: 1 If the cpf of the...
asked by 16.05.2018 / 03:39