获取自增长id（mysql）

Posted on Wed 20 October 2010 in misc

java

PreparedStatement ps =conn.prepareStatement("insert into table (col) values (?)", Statement.RETURN_GENERATED_KEYS);
ps.getGeneratedKeys();

sql

最后插入的id

select last_insert_id();

下一个id

SHOW TABLE STATUS LIKE "table_name";//auto_increment列