I find it strange that creating new tables using a script is not reflected in the connection view, regardless of refreshes (F5). If I disconnect and reconnect the changes are reflected.
I am a raw newbie with sql and databases, however, it seems odd that if I create a column with type INT that is reflected via the mySQL admin tool as INTEGER, and that this fact seems to cause problems when referring to a column as a foreign key. It appears to be type mismatch, even if the documentation seems to imply that INT and INTEGER are aliases.
The joys of learning a new system. Error reporting in SQL is as primitive as AWK and I have to say it could use some updating in that regard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I find it strange that creating new tables using a script is not reflected in the connection view, regardless of refreshes (F5). If I disconnect and reconnect the changes are reflected.
I am a raw newbie with sql and databases, however, it seems odd that if I create a column with type INT that is reflected via the mySQL admin tool as INTEGER, and that this fact seems to cause problems when referring to a column as a foreign key. It appears to be type mismatch, even if the documentation seems to imply that INT and INTEGER are aliases.
The joys of learning a new system. Error reporting in SQL is as primitive as AWK and I have to say it could use some updating in that regard.