Access to more databases
Hello, I would like to know what is the correct way to access two databases on the same server, with two different names, but the same structure (same field tables). I tried to access alternatively one or the other database only by changing the database name, but the data from one database was mixed with the other ! In both insert and select queries, I use the table name without the database prefix (for example "select * from myTable"). Do I have to use "select * from myDatabase.myTable"? Thank you
Answer Answered by Alberto Bonardi in this comment.
Hello, I tried to set "USE myDbName" when opening the database, but unfortunately something is wrong because I keep seeing the data from the other database. Unfortunately I'm afraid I'll have to modify all the queries by adding the prefix with the database name! Thanks anyway