Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: constraint

Optimal way to ignore duplicate inserts? [duplicate]

By adminPosted on September 19, 2023

Question : This question already has answers here: Idiomatic way to implement UPSERT in PostgreSQL (3 answers) Closed 6 years […]

How to set constraint sql 2 colume, Data is not available elsewhere and must be used only

By adminPosted on September 18, 2023

Question : How to set constraint sql 2 colume, Data is not available elsewhere and must be used only. Example […]

Oracle Procedure to Enable/Disable all constraints

By adminPosted on September 11, 2023

Question : I have this nice piece of code: begin for i in ( select constraint_name, table_name from user_constraints where […]

How to add constraint on a varchar column to have at least one non numeric character

By adminPosted on September 7, 2023

Question : I am trying to implement some constraints on tables so that there is no tampering of the data […]

Is it possible to enforce corresponding hierarchies?

By adminPosted on September 6, 2023

Question : I constructed the following toy example to illustrate my question. The left side of the schema describes a […]

Does any kind of constraint in a database have a unique constraint name?

By adminPosted on September 6, 2023

Question : I know that it is possible and even encouraged to add primary key constraints and foreign key constraints […]

Postgres: Can I associate index with FK constraint?

By adminPosted on September 3, 2023

Question : Postgres FK constraint and index are independent. Recently I was looked for unused indexes and found trick to […]

Postgresql uses slower constraint over faster index

By adminPosted on September 2, 2023

Question : I have a few tables (25m records +) which have a very INSERT, UPDATE and DELETE biased workload […]

Making a column immutable in MySQL

By adminPosted on August 30, 2023

Question : I want to make a column in a relation unmodifyable for consistency reasons. The backstory is that I […]

MySQL import LOCK doesn’t prevent PRIMARY key issues

By adminPosted on August 26, 2023

Question : I am using Django and only want to backup mysql data (not it’s structure; Django will do that, […]

  • 1
  • 2
  • 3
  • …
  • 36

Recent Posts

  • ObjID in Page Header
  • Applying data changes from one database to another
  • postgresql won’t install dependencies
  • T-SQL query to show table definition of sys.time_zone_info
  • What is using all my space?
  • Large ibdata file in MySQL
  • What exactly are secondary members acknowledging in replicasets with MongoDB?
  • How to access user information via sys.fn_dump_dblog
  • Instance Startup Modes & Shutdown Modes
  • INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type
  • Restarting primary SQL Server instance with log shipping
  • Fastest way to change a 600GB table indexed key datatype from INT to BIGINT
  • ) c
  • SQL Job runs without it schedule and renaming or deleting it causes other jobs fail
  • mysql emits BINLOG rows even though binlog_­format=­STATEMENT
  • Which mechanism is best for previous data archived in oracle?
  • How large will a MySQL database be relative to the dump file?
  • DBClientCursor::init call() failed
  • Very slow query on table with Blob column [closed]
  • Batch query a lot of MySQLdump files

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding