MySQL Forums
Forum List  »  Newbie

Re: MySQL Update query not giving expected result
Posted by: Gideon Engelbrecht
Date: August 18, 2022 08:13AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL Update query not giving expected result
August 18, 2022 08:13AM


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.