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?