Doubts Mysql ENGINE = FEDERATED

1

Good evening,

Someone could help me, I'm in a project where I need to do table relationships on other servers, I'm using it like this:

Here I am creating the connection url dynamically:

set v_link = concat('mysql://',v_mysql_user,":",v_mysql_senha,'@',v_mysql_server,'/',v_mysql_banco,'/',v_mysql_tabela);

CREATE TABLE tbl_server1 (
 id int(10) NOT NULL,
 campo1 varchar(20) DEFAULT NULL,
 campo2 varchar(1),
 PRIMARY KEY ('id')
 ) ENGINE=FEDERATED 
 DEFAULT CHARSET=utf8
 CONNECTION= v_link;

But when trying to create the table, the error in the v_link variable that I created, does anyone know how to solve it?

    
asked by anonymous 11.09.2017 / 02:02

0 answers