dz¼±µµ¿ò¸»... |
|
ÄÄÇ»ÅÍ¿Í °ü·ÃÀÖ´Â ¸ðµç ÆÁÀ» °øÀ¯ÇսôÙ.
# ±âÁ¸ Ä÷³¿¡ ÀÚµ¿Áõ°¡ ¼Ó¼º ¹× 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
|
ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ ´ç°¨ 4µ¿ 659-1. ÁÁÀº ¼ÒÇÁÆ®¿þ¾î °³¹ß ¿îµ¿º»ºÎ. ´ëÇ¥ ¾ÈµæÈ£ / sinmungo @ hotmail . com Copyright(c) È£°¡°èºÎ. All Rights Reserved. Since 2003. 04 |