Do you know where your variables are? | |
PerlMonks |
Re: (OT) MySQL Helpby UnderMine (Friar) |
on Jun 13, 2006 at 05:48 UTC ( [id://554956]=note: print w/replies, xml ) | Need Help?? |
Because MySQL does not support dynamic SQL you have to write perl to wrap the required SQL. The
INFORMATION_SCHEMA TABLES Table contains the info you need to generate the SQL.
The initial SQL would look like this :- Or you could use table_info on your database handle if you don't need to limit the returned list of tables or are going to filter it in perl. The second dynamic SQL statement would look like :- Hope it help UnderMine
In Section
Seekers of Perl Wisdom
|
|