MySQL: Java code works, but MySQL can't see table
843854Apr 17 2005 — edited Apr 20 2005I'm very experienced with Java and am now moving towards J2EE. My (first) JDBC program connects to a MySQL database. I created the table 'users' from Java code and can add and retrieve values without problems. However, I cannot see the table from the MySQL command line. After switching to the correct database, the command 'show tables;' just returns 'Empty Set'. I guess this isn't such a problem since my code works fine but it is a bit odd.
Any ideas? A Java problem or a MySQL problem? Any help appreciated.