|
MySQL通过AUTO_INCREMENT设置列的自增mysqlCREATETABLEtest_create_tab2(-idINTAUTO_INCREMENT,-valVARCHAR(10),-PRIMARYKEY(id)-);QueryOK,0rowsaffected(0.09sec)mysqlINSERTINTOtest_create_tab2(val)VALUES(\'NOid\');QueryOK,1rowaffected(0.03sec)mysqlselectlast_insert_id()asid;----|id|----|1|----1rowinset(0.00sec)mysqlINSERTINTOtest_create_tab2(val)VALUES(\'NOid2\');QueryOK,1rowaffected(0.03sec)mysqlselectlast_insert_id()asid;----|id|----|2|----1rowinset(0.00sec)mysqlselect*fromtest_create_tab2;-------------|id|val|-------------|1|NOid||2|NOid2|-------------2rowsinset(0.00sec)通过ALTERTABLE语句可以修改自增的数值mysqlALTERTABLEtest_create_tab2AUTO_INCREMENT=100;QueryOK,2rowsaffected(0.25sec)Records:2Duplicates:0Warnings:0mysqlINSERTINTOtest_create_tab2(val)VALUES(\'NOidN\');QueryOK,1rowaffected(0.03sec)mysqlselect*fromtest_create_tab2;--------------|id|val|--------------|1|NOid||2|NOid2||100|NOidN|--------------3rowsinset(0.00sec) |
