I want to know when my migration is complete that the autoincrement values are higher than the highest id that has been inserted. This appears to be the case on my local dev machine but the server has a different version of mySQL. It's just a simple sanity check.
The means I have to access MySQL on the remote server are limited to a mysql command-line client and whatever remote desktop client I can download. I'm using SQLYog at the moment and there is no way to check the autoincrements for a given table as far as I can tell.
aha. I just tried MySQL administrator (desktop GUI made by MySQL folks) and I was able to dig in and find the autoincrements. This software seems REALLY slow though. It takes nearly 30 seconds just to list my tables.
I find it hard to believe there's not an SQL command to show the autoincrement value for a given table in MySQL. How would one check this with the command-line client?