Question

如何在mysql 的查询结果中增加一个字段进去

Answer 1

通过AUTO_INCREMENT设置SQLINSERT语句的时候，要避免指定那个自增的字段.否则会发生主键的冲突。通过ALTERTABLE语句可以修改自增的数值，但是只能增加，不能减少。TRUNCATETABLE语句，会将自增ID重置为零。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)