Using your schema in MariaDB
You follow an example of how to create an external table in MariaDB using your own schema.
GRANT INSERT ANY TABLE TO bob;
GRANT INSERT ANY TABLE TO alice;
Using MariaDB, create an external table based on a user-defined schema.
CREATE SCHEMA bob;
CREATE TABLE bob.country
(
id int,
name varchar(20)
);
insert into bob.country
values (1, 'India');
insert into bob.country
values (2, 'Russia');
insert into bob.country
values (3, 'USA');
CREATE SCHEMA alice;
CREATE TABLE alice.country
(
id int,
name varchar(20)
);
insert into alice.country
values (4, 'Italy');
insert into alice.country
values (5, 'Greece');
insert into alice.country
values (6, 'China');
insert into alice.country
values (7, 'Japan');