在线等:怎样读出数据库里面一个字段的最后一个值?

该值名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 "

Published At
Categories with Web编程
Tagged with
comments powered by Disqus