michaeljdornan
-
Posts
4 -
Joined
-
Last visited
Posts posted by michaeljdornan
-
-
Also, I just removed the ones with the dash in - just to test it, the query runs but only displays the results on screen from the last database in the list, and when I click export it jumps to that last database and only executes and pulls the data from the last table, not all database tables...?
Thanks
-
try using DATABASENAME.TABLENAME in you select query like this
SELECT `NickName`,`FirstName`,`LastName`,`Email` FROM DATABASENAME.Profiles;
Hi, thanks for the help, PravinS is probably the go for me, quick and easy... I built the query, one issue, some of the databases have a - in them so 'database-name.Profiles;' and SQL is complaining about the - .... I've tried removing and leaving a space, no joy, can I wild card it?
Thanks
-
I have 100+ websites all sitting on a single host and accessable via phpMyAdmin. Each one of these websites uses the same database structure.
I want to pull out all the profile specific information to do a mass mail to all my registered users. I'd then need to combine, sort, remove duplicates and upload to my mail client, I have the following query:
SELECT `NickName`,`FirstName`,`LastName`,`Email` FROM `Profiles`;
What I want to know is can I build a query where I can execute a similar statement yet pull the data from every database and just do one export? Then I can clean the data and upload and send everyone an email? Is this possible?
Export data from multiple databases with one single select statement
in MySQL Help
Posted
Hi PravinS that worked great thanks although still issues with any database with a - in it, half the databases didn't return any data and I got this in the log: