Most voted "sql-insert" questions
INSERT is the ANSI standard SQL command to insert records into the database.
Learn more…213 questions
Sort by count of
-
-1
votes1
answer46
viewsSQL-TRIGGER MAKING AUTO NUMBERING WRONG
Hello, I’m studying sql for very little time so I’m sorry if any nomenclature is not ok. I’ve created some triggers for my test database and in some cases it’s working perfectly. In others however…
-
-1
votes3
answers376
viewsMYSQL Insert into com Where not exists
Staff I have the following situation, I have 2 tables, I need to insert in table B data that are in table A, however, should be checked if the data that are in table A already exist in table B, if…
-
-1
votes1
answer23
viewsLoop Laravel making only one Insert in the bank, when it should do several
I’m not getting enough inserts in the database with a loop. At the time of insert, he only makes one. public function store(Request $request){ $contrato = new Contrato(); $contrato->cont_aluno =…
-
-1
votes1
answer27
viewsCopy id with 2 Insert
Well I have two INSERT in the same file, and I want the id of the first INSERT(Tabela1) also go to my second INSERT(table2), I really do not know how to do, I will leave everything more detailed…
-
-1
votes1
answer45
viewsInsert INTO mysql and python error
When I try to make an INSERT INTO in my SQL code, it gives the same error mysql.connector.errors.DataError: 1292 (22007): Incorrect date value: '1998' for column 'validade' at row 1 This is my…
-
-1
votes0
answers31
viewsInsert with PHP in SQL SERVER
Through the POST method I am sending the form data. However at the time of the insert INT type fields in the database give the following error: "sqlsrv_rows_affected() expects Parameter 1 to be…
-
-2
votes1
answer49
viewsWhat do you do when this happens?
I am working on a system in which I must register several data from a form in different tables using mysql. It works like this: The person makes a registration and in the same form requests a…
-
-2
votes1
answer207
viewsMy code does not error, but neither does it compile. Nothing happens :/
I do not know what happens in the code. It does not error, but also does not Insert and does not go to the Login screen and also does not enter the "error"…
-
-2
votes2
answers446
viewsHow to use reserved words in SQL
I need to enter a value in the table, but there is a field with the name 'Status', which is a reserved SQL word. How do I use this field in INSERT? insert into <<tabela>> (status) values…
-
-2
votes1
answer103
viewsInsert Problem: String sql is correct, but does not insert by Java, only manually by Mysql! Procedures attributes date time
Good evening guys! I’m using java and Mysql. At the moment I’m using Procedure for insertion everything happens perfectly the String goes to the bank with all the correct parameters, but something…
-
-2
votes1
answer1670
viewsINSERT conflicted with FOREIGN KEY constraint
I have a problem when performing INSERT in a table in my BD because whenever I try to perform INSERT SQL Server return me this : The INSERT statement conflicted with the FOREIGN KEY constraint…
-
-3
votes1
answer77
viewsERROR WHEN INSERTING PHPMYADMIN
does not insert any information in the database from the error below: Fatal error: Uncaught Error: Call to a Member Function prepare() on null in C: xampp htdocs LOGIN SCREEN classes videos.php:11…
-
-3
votes1
answer40
viewsHow to fix the error ? Error happens when I am trying to insert data into the course table
CREATE TABLE TIPO ( CODIGO INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, -- Código interno (PK) TIPO VARCHAR(32) NOT NULL, -- Descrição PRIMARY KEY(CODIGO) -- Define o campo CODIGO como PK (Primary Key)…