For many releases now, whenever I need to do a SHOW CREATE TABLE on mysql databases, I have been using the MYSQL client instead of SQuirrreL. This is because the output is displayed as a series of numbers. See attached screen shot.
I figured this would get fixed quickly because a lot of people use mysql.
The reason I use SHOW CREATE TABLE is because SQuirreL has another problem with mysql in that it can't handle the mysql column type TINYINT, which it always displays as type BIT. This is in both column descriptions and data display.
Log in to post a comment.