CREATE CATALOG jdbc_mysql_test_one1 PROPERTIES (
"type"="jdbc",
"jdbc.user"="root",
"jdbc.password"="Fulin@888",
"jdbc.jdbc_url" = "jdbc:mysql://192.168.2.125:3306/test",
"jdbc.driver_url" = "file:///usr/share/java/mysql-connector-java.jar",
"jdbc.driver_class" = "com.mysql.jdbc.Driver"
);
show catalogs;
switch jdbc_mysql_test_one1;
show databases;
use test;
SELECT * from jdbc_mysql_test_one1.test.a ;
INSERT into jdbc_mysql_test_one1.test.a values (3,'c');
Doris 连接mysql外表
最新推荐文章于 2024-06-15 00:10:01 发布