获取并将数据库中的最大数量增加1

Question

$sql2 = mysql_query("select MAX(column1) FROM sampledb");

while($iii=mysql_fetch_row($sql2))

{

$iii['MAX(column1)'];

}
$numplus = $iii+1;

echo"$numplus";

im a newbie pls help me T_T

Answer 1

What you are looking for here is the AUTO_INCREMENT column attribute, which instructs MySQL to automatically use the next available value for a primary key.