Doubt Mysql ENGINE=FEDERATED

Asked

Viewed 39 times

1

Good night,

Someone managed to help me, I am in a project where I need to make relationships of tables in other servers, I am using as follows:

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, from the error in the v_link variable I created, someone knows how to solve?

  • I was able to resolve with this link https://stackoverflow.com/questions/1273701/variables-in-create-statement

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.