I’m using an input to allow user’s to select files from their computer and add it to a list. I’m doing this by using a promise to load the files and creating an array of promises and adding that to my state React JS I’m then mapping through my files array to add those files to a list o…
Tag: sql-insert
In PostgreSQL, I’m performing an UPSERT on 1000 rows, I’m using ON CONFLICT … DO NOTHING, if 1 row fails, do the other 999 get inserted?
I’m trying to understand how the ON CONFLICT clause works. What I want, is if an insert fails for any reason, I want it to do nothing with the row, but continue processing the other items in the bulk insert. Here’s my scenario. I’m building a bulk insert query, with 1000 rows to be inserted.…
Generate series of random size data in MySQL
I need to populate table with random size of data for each dependency record. First table is table of products (named products): And the second table is table that contains displays of that product (named product_displays). Each display is another row: Like you can see date will always be the same value, but …
SQL: INSERT multiple different hardcoded values in one column
I could not find a solution for this yet. I want to insert multiple rows with 2 or more different hardcoded values, but also with data that I get from another table. Example: I want to add 2 items into a table for a user that has the ID = ‘0’ in another table without running 2 queries. This is
How to compare and update an inserted value to existing value using a trigger?
I am learning triggers for the first time in SQL, and I am unsure of how to write/phrase a certain trigger. I am attempting to make a trigger that would check to see if a value within an attempted …
INSERT into statement not working in oracle when using INSERT INTO .. SELECT * FROM
I have vh_emp table whose table structure is(This is empty table): I am taking data from employee table as source table where I wrote some query to match with vh_emp table: SELECT e.emp_id …
Trouble inserting value into a TEXT column with Postgres
I am getting an error when I try to insert an alphanumeric value into a TEXT column in a Postgres DB. This is the table definition ]1 This is the query I am using to insert data into the table This is the error message I get ERROR: syntax error at or near “a0032000947363339343638” LINE 12: 55.2047…
Error: ‘duplicate key value violates unique constraint’ even when checking with ‘where not in’
I get the error: ‘duplicate key value violates unique constraint’ even when checking if the primary key is already in the table in which I want to insert. I have tried to check with either ‘where not y.a in…’ as well as with ‘where not exists…’ The code I use ri…
Migrate data from one table to the other
I have two tables and I have to transfer data from one to the other. Table 1: employees home_address string Table 2 emp_address address string emp_id int is_permanent bool I need to …
Stored Procedure Data Type Conversion Error
I try to execute the following SP it gives me this following error. Msg 8114, Level 16, State 5, Procedure TEST, Line 55 [Batch Start Line 12] Error converting data type nvarchar to …