Automatic Web Traffic Generator

How to Check for Duplicates Before Inserting Into SQL

When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present due to a duplication issue. You can use a simple alteration ... read more

Check for duplicates before insert

That said, I worked out a few errors in the jsp, and have it down to an SQL syntax error ... the only way to prevent inserting it again, is doing a select first. And to answer your question "Check for ... read more

SQL Server Removing Duplicates

Before we run through them if you want to follow along then run the following SQL to create two ... to do a SELECT DISTINCT into a new table to remove the duplicates, then we’re having to clear out ... read more

How to Protect Your Website Against SQL Injection Attacks

This is one of the simplest forms of SQL injection. With a little more effort, the same user can insert new user accounts ... including hidden form values, before submitting them to the server. And if ... read more

Guru: One Way To Deal With Two Null Formats

First, let’s create a table and put some data into ... you try to insert a row with a null ID, you’ll get message SQL0545 (INSERT, UPDATE, or MERGE not allowed by CHECK constraint) because a primary ... read more

Oracle's Bulk Collect and Limit Can Be A Problem

emp_c.count loop 15 insert into emp_test (empno, ename, sal) 16 values (emp_c(i).empno, emp_c(i).ename, emp_c(i).sal); 17 end loop; 18 19 end loop; 20 21 commit; 22 23 end; 24 / PL/SQL procedure ... read more

Check For Duplicates Before Inserting into Access 2010 DB

I've written this code (that works) to inserts registration details into an Access 2010 DB from an aspx registration page. How do I check for duplicates Email before inserting a new record into the DB ... read more

Why & How to Tackle Technical SEO Before Link Building

One important technical SEO consideration that should be ironed out before any link building is duplicate ... check can help you reveal exactly what’s working (or not working) under the hood right now ... read more

Fixing a Race Condition

Our product team let me know that we check for interview updates before displaying ... potential interval for a duplicate interviewer. Let’s dive into database transactions real quick to understand ... read more

Loading CSV Files Using Dynamic SQL

Speaking at SQL ... into the database. You will also need to check to see if the file already has a corresponding table, and if does, you will need to see if the data that you are importing already ... read more

How to Use JSON Data Fields in MySQL Databases

In my article SQL vs NoSQL: The Differences ... Whole JSON documents can be passed in INSERT or UPDATE statements. For example, our book tags can be passed as an array: INSERT INTO `book` (`title`, ... read more

Mutating Table Error In Oracle: Why It Happens And What You Can Do About It

Insert 10 rows into ... before the triggering event causes one of the sections to fire, thus there is no in-process data update to interrupt. Let's look at an example from a previous article to see ... read more