sqlite : autoincrement
ÃÑ ÆäÀÌÁö ¼ö : 3224

Àüü ÇÔ¼ö/¿ë¾î»çÀü
Facebook Joinc ±×·ì   Joinc QA »çÀÌÆ®



joinc´Â Firefox¿Í chrome¿¡¼­ Å×½ºÆ® Çß½À´Ï´Ù. IE¿¡¼­´Â Å×À̺íÀÌ ±úÁö°Å³ª À̹ÌÁö°¡ º¸ÀÌÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù. ƯÈ÷ ±¸±Û DocsÀ̹ÌÁöÀÇ °æ¿ì ¿¢¹Úó¸®µÉ ¼ö ÀÖ½À´Ï´Ù.

auto increment

2.x ¹öÀü

mysqlÀº autoincrement Çʵ带 Áö¿øÇÑ´Ù. ±×·¸Áö¸¸ sqlite(2.x ¹öÀü ±âÁØ)´Â Áö¿øÇÏÁö ¾Ê´Â´Ù.

SQLite´Â rowid·Î ¹°¸®ÀûÀÎ ·¹ÄÚµå ¹øÈ£¸¦ ¾Ë¾Æ³¾ ¼ö ÀÖ´Ù. ±×·¯¹Ç·Î ´Ü¼øÈ÷ autoincrement¿ëÀ¸·Î »ç¿ëÇÒ °Å¶ó¸é rowid·Îµµ ÃæºÐÇÏ´Ù.

select rowid, myage from mytest; 
select * from mytest where rowid=1; 
 

query·Î ÇØ°áÇÏ´Â ¹æ¹ýµµ ÀÖ±äÇÏ´Ù.
create table t1(a integer primary key, b);  
insert into t1 values((select max(a) from t1)+1, 234);  
 

3.x ¹öÀü

  • 3.0 ¹öÀü¿¡¼­ Áö¿øÇÏ´ÂÁö È®ÀÎÇØ ºÁ¾ß ÇÒ°Í °°À½ - 2010/2/5
EmailÀ» ±âÀÔÇϸé, ´ñ±ÛÀÌ ¸ÞÀÏ·Î Àü´ÞµË´Ï´Ù.