Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/629307240961441792
Removed tag from title; some formatting.
Source Link
mustaccio
mustaccio
  • 26.9k
  • 24
  • 58
  • 74

MySql - Does an empty column value occupy same storage space as a filled column value?

I have a table with 2 columns. The type of both columns is set to varchar(38)varchar(38). If I create a row with an empty value for one of the columns, will it take same storage space as if the value was not empty?

In other words, will MySqlMySQL reserve storage space for the column (depending on its type) when a row is created?

MySql - Does an empty column value occupy same storage space as a filled column value?

I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with an empty value for one of the columns, will it take same storage space as if the value was not empty?

In other words, will MySql reserve storage space for the column (depending on its type) when a row is created?

Does an empty column value occupy same storage space as a filled column value?

I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with an empty value for one of the columns, will it take same storage space as if the value was not empty?

In other words, will MySQL reserve storage space for the column (depending on its type) when a row is created?

deleted 1 character in body
Source Link
Craig Efrein
Craig Efrein
  • 9.7k
  • 12
  • 62
  • 97

Lets say I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with an empty value for one of the columncolumns, will it take same storage space as if the value was not empty? 

In other words, will MySql reserve storage space for the column (depending on its type) when a row is created?

Lets say I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with empty value for one of the column, will it take same storage space as if the value was not empty? In other words, will MySql reserve storage space for the column (depending on its type) when a row is created?

I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with an empty value for one of the columns, will it take same storage space as if the value was not empty? 

In other words, will MySql reserve storage space for the column (depending on its type) when a row is created?

Source Link
Haris ur Rehman
Haris ur Rehman
  • 363
  • 1
  • 3
  • 7

MySql - Does an empty column value occupy same storage space as a filled column value?

Lets say I have a table with 2 columns. The type of both columns is set to varchar(38). If I create a row with empty value for one of the column, will it take same storage space as if the value was not empty? In other words, will MySql reserve storage space for the column (depending on its type) when a row is created?