Tuesday, December 14, 2010

Get the Auto_increment value of a Table in MySQL

SELECT auto_increment 
FROM information_schema.tables 
WHERE table_name='the_table_you_want';

No comments:

Post a Comment