blackcell Posted January 23, 2009 Share Posted January 23, 2009 Hello, I have tried to find what I need on the mysql site but im not for sure. I know the basics of mysql until it starts with the joins. Basically, I have a ticket system I developed. I want to be able to synchronize two systems by "importing" the table 'tickets_data' hosted on system 2 to the table 'tickets_data_hostname' to system 1. I need to modify my sql query that shows all this data so that it pulls the data from both tables at once (seemingly). The table structure is identical but the data contents are different. # Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 # MySQL client version: 5.1.30 Edit1: mysql & apache version Quote Link to comment https://forums.phpfreaks.com/topic/142110-solved-synching-data-with-mirrored-table-structures/ Share on other sites More sharing options...
kkubek Posted January 23, 2009 Share Posted January 23, 2009 I'm not exactly clear on what you're trying to do, but if you want data from 2 identical tables, you'd use a UNION select * from table1 UNION select * from table2 You'd add a where clause to both select if you wanted only a subset Quote Link to comment https://forums.phpfreaks.com/topic/142110-solved-synching-data-with-mirrored-table-structures/#findComment-744326 Share on other sites More sharing options...
blackcell Posted January 23, 2009 Author Share Posted January 23, 2009 thank you, i believe thats it. Quote Link to comment https://forums.phpfreaks.com/topic/142110-solved-synching-data-with-mirrored-table-structures/#findComment-744573 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.