Hi,
I’ve connected NoCoDb to an external mysql database, but it seems to be using the wrong field as the identifier. The table looks like this:
mysql> describe customers;
+----------------------+--------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------------------+-----------------------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| cid | char(11) | YES | | NULL | |
| first_name | char(20) | YES | | NULL | |
| last_name | char(20) | YES | | NULL | |
| address | char(20) | YES | | NULL | |
| city | char(20) | YES | | NULL | |
| state | char(2) | YES | | NULL | |
| zip | char(5) | YES | | NULL | |
But NoCoDb is picking the cid field as the index where id is clearly the correct choice. How can I fix this?
Mike.