ÄÄÇ»ÅÍ¿Í °ü·ÃÀÖ´Â ¸ðµç ÆÁÀ» °øÀ¯ÇսôÙ.

# ±âÁ¸ Ä÷³¿¡ ÀÚµ¿Áõ°¡ ¼Ó¼º ¹× primary key Ãß°¡

ALTER TABLE table_name MODIFY coulmn_name INT NOT NULL AUTO_INCREMENT PRIMARY KEY;

# ±âÁ¸ Ä÷³¿¡ ÀÚµ¿Áõ°¡ ¼Ó¼º Ãß°¡

ALTER TABLE table_name MODIFY coulmn_name INT NOT NULL AUTO_INCREMENT;

# ÀÚµ¿ ¼Ó¼º°ª ÃʱâÈ­

ALTER TABLE table_name AUTO_INCREMENT=1;

# ÀÚµ¿ ¼Ó¼º ¹× primary key °ªÀ» °®´Â ½Ã±ÔÄ®·³ Ãß°¡

ALTER TABLE table_name ADD COLUMN coulmn_name INT(9) NOT NULL AUTO_INCREMENT PRIMARY KEY;

# ÀÚµ¿ ¼Ó¼º °ªÀ» °®´Â ½Ã±ÔÄ®·³ Ãß°¡

ALTER TABLE table_name ADD COLUMN coulmn_name INT(9) NOT NULL AUTO_INCREMENT;

# ƯÁ¤Ä÷³ µÚ¿¡ Ä÷³ Ãß°¡

ALTER TABLE table_name ADD new_coulmn_name INT(9) AFTER coulmn_name;




TAG : ALTER  TABLE  table_name  MODIFY  coulmn_name  INT  NOT  NULL  AUTO_INCREMENT  PRIMARY  KEY 

tagÁ¦¸ñ³»¿ëÀÛ¼ºÀÚ