SQL - MySQL Data Types
ยท
๐Ÿงฉ SQL
โœ… Data TypesCHAR(10): ๊ธธ์ด๊ฐ€ 10์ด ๋  ๋•Œ๊นŒ์ง€ ๊ณต๋ฐฑ์„ ๋„ฃ์–ด ์ฑ„์šด๋‹ค. (CHAR๋Š” 255๊ฐ€ ์ตœ๋Œ€ ๊ธธ์ด)VARCHAR(10): ์ตœ๋Œ€ ๊ธธ์ด๊ฐ€ 10 ENUM('male', 'female'): ์ง€์ •ํ•œ ๊ฐ’๋“ค ์ค‘ ํ•˜๋‚˜๋งŒ ๊ฐ’์œผ๋กœ ๊ฐ€์งˆ ์ˆ˜ ์žˆ์Œ SET('1', '2', '3'): ์ง€์ •ํ•œ ๊ฐ’์—์„œ ์—ฌ๋Ÿฌ ๊ฐœ๋ฅผ ๊ฐ’์œผ๋กœ ๊ฐ€์งˆ ์ˆ˜ ์žˆ์Œ TINYTEXT: 255 ์ดํ•˜TEXT: 65,535 ์ดํ•˜MEDIUMTEXT: 16MB ์ดํ•˜LONGTEXT: 4GB ์ดํ•˜ TINYBLOB: 255Byte ์ดํ•˜BLOB: 64KB ์ดํ•˜MEDIUMBLOB: 16MB ์ดํ•˜LONGBLOB: 4GB ์ดํ•˜ TINYINT: SIGNED -> -128 to 127 | UNSIGNED -> 0 to 255SMALLINT: SIGNED -> -32,7..