MySQL Forums
Forum List  »  Federated Storage Engine

Problems updating federated table
Posted by: Daniel Ortiz
Date: June 21, 2017 10:31AM


Server A: create view federated_view as SELECT ....

Server B: create table tabela_federada (A, B, C) ENGINE=FEDERATED CONNECTION='mysql://user:paswd@:3306/database/federated_view';

When i perform a update on federated table, mysql return
OK, but the value was not updated:

mysql> update tabela_federada set incidentes_utilizados = 1 where customer_id = 'teste' and incidentes_utilizados = 10;
Query OK, 1 row affected (0.17 sec)

mysql> select * from tabela_federada where customer_id = 'teste'\G
incidentes_utilizados: 10
bugs_qualificados: 3
requisicoes_utilizadas: 2
horas_disponiveis: 4.00

Options: ReplyQuote

Written By
Problems updating federated table
June 21, 2017 10:31AM

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.