RichRock : Running Free

While I wait for the backups to complete, I find myself drifting around on the internet. In my open-source meanderings (on Firefox obviously), I find this. A spiffy collection of cool tech-orientated cartoons, with one of my favourite Dilbert strips at the top.

Plus I want this. As I’ve been doing a lot of MySQL stuff recently, it only seems appropriate.

Simple - in a mysql prompt, type this:

SHOW TABLE STATUS LIKE 'tablename';

Where the tablename is the table you need to find the next auto_increment value. It should be the 9th value in the results.