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

Tag: default-value

Adding a default constraint in Oracle while altering a column

By adminPosted on January 25, 2023

Question : I’m new to Oracle. I need to port a SQL Server command to Oracle. I want to alter […]

Calculated Field Updating Every Row

By adminPosted on December 27, 2022

Question : I added a calculated field to my table, and only want to update NULL rows (or “new” rows). […]

Assign value to a field after checking a condition

By adminPosted on December 7, 2022

Question : I have this query: ALTER TABLE MERCHANTS ADD COLUMN merchant_image bytea, ADD COLUMN merchant_logo bytea, ADD COLUMN merchant_address […]

Assign value to a field after checking a condition

By adminPosted on October 17, 2022

Question : I have this query: ALTER TABLE MERCHANTS ADD COLUMN merchant_image bytea, ADD COLUMN merchant_logo bytea, ADD COLUMN merchant_address […]

alter table (mysql) adding column with default value of space (‘ ‘)

By adminPosted on October 1, 2022

Question : On my Mac, using 5.5.11 MySQL Community Server (GPL) alter table foobaz add column ( extendedTitle varchar(3000) DEFAULT […]

Default value for UUID column in Postgres

By adminPosted on June 13, 2022

Question : In Postgres 9.x, for a column of type UUID, how do I specify a UUID to be generated […]

Is DEFAULT NULL and ‘nullable value without default’ completely the same?

By adminPosted on June 9, 2022

Question : ALTER TABLE test_table ADD COLUMN a DEFAULT NULL; vs. ALTER TABLE test_table ADD COLUMN a; Both columns will […]

PostgreSQL, what is the hostname address of my default database?

By adminPosted on May 20, 2022

Question : I just created a PostgreSQL database on my laptop (following these instructions), which is running Linux CentOS 7. […]

Confused on how a value gets added with the DEFAULT constraint

By adminPosted on March 3, 2022

Question : A recent definition I’ve read about Default Constraints: DEFAULT is specified for a column to assign a column […]

How do I an add a DEFAULT on a column if the table already exists?

By adminPosted on January 20, 2022

Question : I want to add a DEFAULT for a timestamp column in PostgreSQL. With SQL Server you use ALTER […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table
  • Database layout to keep track of the “freshness” of a column value in a specific row
  • MySQL Computed Column counting other rows with attributes relative to this one
  • How to design tables for airbnb style booking system [closed]
  • mysql restart won’t kill child processes on CentOS
  • Postgresql create index concurrently

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