MySQL
Connecting to MySQL may result in various errors. See below for some of the most common. The solutions are based on that at least DbVisualizer 12.1.3 is...
Wed, 22 May, 2024 at 11:49 AM
Accessing a table in the Data tab or in the SQL Commander that contain a DATETIME column sometimes report the following error and highlights the column in...
Mon, 11 Dec, 2017 at 11:12 AM
This behaviour is due to the MySQL database driver that handles tinyint(1) as bit by default. To change this, open the connection, navigate to the Prope...
Mon, 18 Mar, 2024 at 11:13 PM
MySQL supports both encryption and secure authentication. This solution describes how to connect using DbVisualizer to a secured mySQL server. The descripti...
Wed, 17 Feb, 2021 at 11:34 PM
I can't see bar as column header in the result set for the following query. I always get foo. select foo as 'bar' from mytable Solution: In t...
Wed, 12 Jul, 2017 at 7:55 PM
Formatting of YEAR values is controlled by the MySQL driver, and by default they are displayed as dates (for more information, please see https://dev.mysql....
Fri, 22 Mar, 2024 at 10:26 AM
Using the inline editor for JSON columns can result in the MysqlDataTruncation problem. Solution: In the connection tab check Buffer All Rows for a Res...
Wed, 12 Jun, 2024 at 3:54 PM