Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple mysqlserver connection problem

 
Eshwin Sukhdeve
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can have as many connections to as many different databases as you want at one time.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic