![]() BTW, I am aware of the potential issues with a date being stored as '' and is one reason that I was trying to use this tool so that I could find one or more ways to address this occurrence from an older database that is to be used in a new(er) environment. Running this again: SELECT test_date_available FROM test WHERE test_date_available > '' The above causes no change in the response and (incorrectly) appears as if there is still one row/record returned. For information about installing MySQL (including the MySQL command-line client), see Installing. If I then run: SELECT test_date_available FROM test WHERE test_date_available >= '' I get one row. For more information, see the Download MySQL Workbench page. ![]() Initial query: DROP TABLE IF EXISTS test CREATE TABLE test ( test_id int(11) NOT NULL auto_increment, test_date_available datetime default NULL, PRIMARY KEY (test_id) ) ENGINE=MyISAM INSERT test (test_date_available) VALUES ('') SELECT test_date_available FROM test WHERE test_date_available > '' The above causes no response. When I change the SELECT query to return a result, I get the (undesired but expected) result. The following series of queries will expectedly provide no result, but I would expect that the system response would be something like no results returned or nothing to show, but when run as the first query, nothing happens. ![]() Select Version: Select Operating System: Windows (x86, 32-bit), MSI Installer. MySQL Server 8.1 and higher also bundle MySQL Configurator, a tool that helps configure MySQL Server. ![]() As of MySQL 8.1, use a MySQL products MSI or Zip archive for installation. The current lack of response leads one to think that either there is a "timeout" occurring in the connection, or that the tool is not functional. Note: MySQL 8.0 is the final series with MySQL Installer. No indication is provided that a query returns no results. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |