
»õ·Î¿î Å×À̺íÀÇ »ý¼º
CREATE TABLE Å×À̺í¸í (
Çʵå¸í µ¥ÀÌÅÍŸÀÔ [NOT NULL]
{, Çʵå¸í µ¥ÀÌÅÍŸÀÔ [NOT NULL]}*
[, PRIMARY KEY(Çʵå¸í)]
)
[]¾ÈÀÇ »ý·«°¡´ÉÇѰÍ, {}*¾ÈÀº ¹Ýº¹°¡´É ¼±Åà »çÇ×
-----------------------------------------------------------------------
INT - 4 BYTES Á¤¼ö
CHAR(M) - ¹®ÀÚÀÇ ¼ö°¡ M°³ÀÎ ¹®ÀÚ¿
VARCHAR(M) - ¹®ÀÚÀÇ ¼ö°¡ ÃÖ´ë M°³ÀÎ ¹®ÀÚ¿
TEXT - ¹®ÀÚÀÇ ¼ö°¡ ÃÖ´ë 65535°³ÀÎ ¹®ÀÚ¿
-----------------------------------------------------------------------
* PRIMARY KEY - Å×ÀÌºí³»¿¡ ÀúÀåµÈ ·¹Äڵ带 ´Ù¸¥ ·¹ÄÚµå¿Í ±¸º°½ÃÄÑÁÜ
(¿¹) ¹øÈ£-1,2,3,Àº ¹Ýº¹µÇÁö ¾Ê°í ´Ù¸¥·¹ÄÚµå¿Í ºñ±³°¡ µÈ´Ù
=======================================================================
½Ç·Ê
-----------------------------------------------------------------------
CREATE TABLE userdb (
name CHAR (8),
id VARCHAR (10) NOT NULL,
email VARCHAR (40),
sex CHAR(1),
PRIMARY KEY(id)
)
======================================================================
= À̸§ ¾ÆÀ̵ð ÀüÀÚ¿ìÆíÁÖ¼Ò ¼ºº°À» Çʵå·Î °®´Â Å×À̺í
id´Â primary keyÀ̹ǷΠnot null·Î ¼³Á¤
**********************************************************************
* ´Ù¸¥À̸§À¸·Î À§ÀÇ Å×À̺íÀ» º¹»çÇÑ´Ù¸é
CREATE TABLE userdb2 AS SELECT * FROM userdb
**********************************************************************
* ƯÁ¤ µ¥ÀÌÅ͸¸À» °¡Á®¿À°íÀÚ ÇÒ °æ¿ì
CREATE TABLE userdb3 AS SELECT name,id FROM userdb
********************************************************************** | |