About 1,805,158 results (5,091 milliseconds)
JOOQ INSERT IGNORE
https://groups.google.com/g/jooq-user/c/LvfNGIKpvn8 HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere (which have the MERGE ... For example, without IGNORE , a row that duplicates an existing UNIQUE index ...
ActiveRecord/Arel delete with joins?
https://groups.google.com/g/rubyonrails-talk/c/TnUTZo7Gmi4/m/oRQomT29TboJ Oct 28, 2011 ... ... primary keys for a given adapter. I'm familiar with the Postgres ... servers where each server will get given a batch of id values it could
Diagnose issues | Datastream | Google Cloud
https://cloud.google.com/datastream/docs/diagnose-issues For more information about supported editions of SQL Server, see Overview of SQL Server as a source. ... rows if the primary key is different. For more ...
ROWID in Sybase ?
https://groups.google.com/g/comp.databases.sybase/c/IZVkdQH2fyY key can not be accurately updated or deleted using non-cursor SQL. Any attempt to use any UPDATE or DELETE on a table without a primary key runs the risk of ...
Prepare your source for conversion | Database Migration Service 1 ...
https://cloud.google.com/database-migration/docs/oracle-to-alloydb/configure-your-ora2pg ... SQL for SQL Server ... Data Manipulation Language UPDATE and DELETE statements on tables without primary keys might cause duplicate records because Database ...
Slow loading for large (~70k articles) site
https://groups.google.com/g/joomla-dev-general/c/sVFw9reqGGw I'll pass on that as I am a novice on MS SQL Server and PostgreSQL. ... content_item_id - the table description says it is a primary key to the content ...
multiple image uploader
https://groups.google.com/g/xataface/c/4AUPhHA7PQc/m/KcZSlRs-vMAJ May 21, 2014 ... PRIMARY KEY (`id`). ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ... if I try and delete the duplicates it will delete the entire record.
Using Guid as Primary Key
https://groups.google.com/g/sqlalchemy/c/WAHaPIuzqZQ I've used surrogate PKs for decades without data duplication issues. That ... I used guid primary keys in Microsoft's SQLServer (around 4-5 years ago) ...
RFC: "UPSERT" in PostgreSQL
https://groups.google.com/d/msgid/django-developers/542992BD.2050501%40oddbird.net generally. This is a non-standard syntax that is somewhat comparable to MySQL's. INSERT ... ON DUPLICATE KEY UPDATE, while being more flexible and
Unique index or primary key violation in FullText indexes tables ...
https://groups.google.com/g/h2-database/c/rVtF58dpj9A My opinion is that this is a bug in H2. I managed to "solve" the problem by deleting all records in the table ... In the meantime, I recreated my database without ...
Multi row insert with On Duplicate Update (Microsoft Sql Server)
https://groups.google.com/g/jooq-user/c/YivILNbGMXo Jul 5, 2016 ... ... database that supports adding several VALUES() clauses and ON DUPLICATE KEY UPDATE clauses. ... primary key). If I use onDuplicateKeyIgnore - I ...
Enscribe Files
https://groups.google.com/g/comp.sys.tandem/c/aQM3gGWrJSk Does anyone know how to boost the performance of writes to an enscribe (Key Sequence) file ? Currently we have partitioned the database, tried to perform ...
ms-access faq
https://groups.google.com/g/comp.databases.ms-access/c/8qkhvmRjMgQ duplicate information in the primary key fields. You can run a make-table query to eliminate the duplicate data, but if key fields for two or more records ...
barnyard failing to start upon pulled pork update
https://groups.google.com/g/security-onion/c/QuNzlnjFiDY SQL query which fails because one with the same primary key had been done ... mysqlexec/db server: Duplicate entry '3-1393328' for key 'PRIMARY'. in the ...
How to do a simple INSERT OR UPDATE?
https://groups.google.com/g/jooq-user/c/w-WFrkCuM6s If I use store() on a newly created and filled record, I'll get a violation exception if the primary key already exists. ... SQL Server, and Sybase SQL Anywhere):.
PSQLException: ERROR: null value in column "id" violates not-null ...
https://groups.google.com/g/scalaquery/c/OEOF8HNzn2U But where you define id with column[ ] it can be without, See my snippet I ... " While some database systems allow inserting proper values into AutoInc ...
failure of auto increment in inndb (mysql)
https://groups.google.com/g/django-users/c/h4lE7sQ_aRM Jan 27, 2014 ... 3) You delete record with ID 123 again 4) MySQL reboots, resetting ... MySQL started as a non-ACID query server (not a full relational database ...
Schemas overview | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/schema-and-data-model Mar 21, 2025 ... Only GoogleSQL-dialect databases can have tables without a primary key. ... primary key values, with child rows inserted between parent rows.
Kafka Connect JDBC produces duplicate messages in timestamp+ ...
https://groups.google.com/g/confluent-platform/c/QVhuLqoTLvE ... data (due to keying on each row's unique primary key). ... I am using timestamp+incrementing with a query, on SQL Server and missing records here and there.
Adding a primary key in a huge CloudSQL table
https://groups.google.com/g/google-cloud-sql-discuss/c/N9kWoOS67VY/m/fmZwLfpcBQAJ Apr 25, 2016 ... It is composed of 52 million rows of 20 columns each. I would like to add one, since I will remove duplicates and doing so without primary key ...