ClickHouseClient icon indicating copy to clipboard operation
ClickHouseClient copied to clipboard

Update Query not working

Open mr-aybee opened this issue 1 year ago • 1 comments

Update query is not working

ALTER TABLE `default`.`test_Bank` 
UPDATE Key = @Key, Number = @Number, Name = @Name, Code = @Code 
WHERE Id = @Id

in mutations it is giving error Table does not exists image

mr-aybee avatar Apr 05 '24 19:04 mr-aybee

As ClickHouse doesnt support natively, we have to hint the client. cmd.ParametersMode = ClickHouseParameterMode.Serialize;

lokeshwer avatar Jan 21 '25 17:01 lokeshwer