I have to execute this query using jdbc with mysql.
stmt.executeUpdate(CREATE TABLE Dashboard1.products as SELECT p.prod_id,p.prod_name,p.description FROM dashboard.products p order by p.i)
I have 2 machine .both system have mysqlserver. Dashboard1.products database is in one machine and dashboard.products in one machine.
so is it posible to connect with multiple mysqlserverdatabase at a time.