Workbench update query unresponsive
The mind boggles. All of a sudden Mysql Workbench (8.0) does not update even the simples of queries. Eg. my table create statement is :
CREATE TABLE `test1` (
`date` date DEFAULT NULL,
`Date1` date DEFAULT NULL,
`Date2` date DEFAULT NULL,
`Value` int DEFAULT NULL,
`OrgVal` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
The following query has no effect - only one line is displayed all with NULL values:
update test
set Test_col1 = 'Test';
select * from test
No warning messages - just no result.
Subject
Views
Written By
Posted
Workbench update query unresponsive
484
August 18, 2022 08:24AM
238
August 18, 2022 09:56PM
232
August 19, 2022 02:17AM
240
August 19, 2022 12:08AM
194
August 19, 2022 12:45AM
254
August 19, 2022 02:23AM
280
August 19, 2022 05:28AM
243
August 19, 2022 03:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.