该值名id,自动递增的。用什么sql语句可以直接读出最后的id的数字?
---------------------------------------------------------------
1
2mysql_connect("localhost", "mysql_user", "mysql_password") or
3die("Could not connect: " . mysql_error());
4mysql_select_db("mydb");
5
6mysql_query("INSERT INTO mytable (product) values ('kossu')");
7printf ("Last inserted record has id %d\n", mysql_insert_id());
---------------------------------------------------------------
$sql="select * from myTable order by id desc limit 0,1"; //得到最后一個 id 的數據
$result=mysql_query($sql);
$row=mysql_fetch_array($sql);
---------------------------------------------------------------
$sql="select id from myTable order by id desc limit 1";
---------------------------------------------------------------
select max(id) from arinvoice;
最直接的方法。
---------------------------------------------------------------
select max(id) from 表名
---------------------------------------------------------------
last_insert_id()
---------------------------------------------------------------
$sql="select max(id) from myTable "