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
– Anderson Oliveira