[MySQL] String Types

SQL 2008. 9. 19. 14:19
  • The CHAR and VARCHAR Types

Value CHAR(4) Storage Required VARCHAR(4) Storage Required
'' ' ' 4 bytes '' 1 byte
'ab' 'ab ' 4 bytes 'ab' 3 bytes
'abcd' 'abcd' 4 bytes 'abcd' 5 bytes
'abcdefgh' 'abcd' 4 bytes 'abcd' 5 bytes

 

  • The BINARY and VARBINARY Types

 

  • The BLOB and TEXT Types

A BLOB is a binary large object that can hold a variable amount of data. The four BLOB types are TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB. These differ only in the maximum length of the values they can hold. The four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. See Section 10.5, “Data Type Storage Requirements”.

 

  • The ENUM Type

http://dev.mysql.com/doc/refman/5.1/en/enum.html

 

  • The SET Type

http://dev.mysql.com/doc/refman/5.1/en/set.html

설정

트랙백

댓글

  • longchamp 2013.07.28 17:40 ADDR 수정/삭제 답글

    다른 남자 부르면서 울거면 나한테 이쁘지나 말던지

[MySQL] Date and Time Types

SQL 2008. 9. 19. 14:19

Data Type Zero” Value
DATETIME '0000-00-00 00:00:00'
DATE '0000-00-00'
TIMESTAMP '0000-00-00 00:00:00'
TIME '00:00:00'
YEAR 0000

설정

트랙백

댓글

  • supra 2013.07.27 10:01 ADDR 수정/삭제 답글

    눈을 감아봐 입가에 미소가 떠오르면 네가 사랑하는 그 사람이 널 사랑하고 있는거야.

[MySQL] Numeric Types

SQL 2008. 9. 19. 14:19

Type Bytes Minimum Value Maximum Value
    (Signed/Unsigned) (Signed/Unsigned)
TINYINT 1 -128 127
    0 255
SMALLINT 2 -32768 32767
    0 65535
MEDIUMINT 3 -8388608 8388607
    0 16777215
INT 4 -2147483648 2147483647
    0 4294967295
BIGINT 8 -9223372036854775808 9223372036854775807
    0 18446744073709551615

설정

트랙백

댓글

  • coach outlet 2013.07.27 04:22 ADDR 수정/삭제 답글

    당신 매력있어, 자기가 얼마나 매력있는지 모르는게 당신매력이야

[MySQL] Data Type Storage Requirements

SQL 2008. 9. 19. 14:19

http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html

설정

트랙백

댓글

  • ugg boots 2013.07.27 05:58 ADDR 수정/삭제 답글

    슬퍼서 우는거 아니야..바람이 불어서 그래..눈이 셔서..