automatic detection of table index field

[aequitas]

Instead of having to specify the primary key field of a table manually for every table, could it be auto detected instead?

[ludesign]

You can run this query against every table and you'll have the primary key.

SHOW KEYS FROM table_name WHERE Key_name = 'PRIMARY'

I took a quick look at the source code and it seems quite easy to implement.

• Edit - I have forked this project and added auto collection of table indexes. It was even easier as the original author was using SHOW COLUMNS FROM. Also will work with composite PRIMARY KEY tables.

I will send pull request, until then you can checkout/pull the changes from my repository.