Can someone please help me make this SQL script from Oracle to work with mySQL ? Any help would be appreciated.
select c.table_name child_table,
from sys.all_constraints l,
where l.constraint_type = 'R'
and l.constraint_name = c.constraint_name
and l.r_constraint_name = p.constraint_name
and l.owner = c.owner
and l.r_owner = p.owner
and c.position = p.position
You'll have to rewrite the script completely (as Piper suggested), but the functionality should be available. Unfortunately, I'm working on an Oracle DB at the moment and don't have access to a MySQL resource. When I free up later today, I'll see if I can put together a similar query that's MySQL-centric.
On the other hand, I think Piper might be wrong about the notation. Unless I misunderstand the issue, I've used said notation to access one database from another as long as it's on the same box and I've got proper permissions on each. It's worked fine.
Of course, I'm pretty new to MySQL (coming from an Oracle/SQL Server environment) so I may have misunderstood the point.