Re: records returned by DBI::selectall_hashref() are not ordered

I use sort keys to solve the problem. Thanks a lot! Yu

How to check the existence of a table?

I use DBD::SQLite as my database and I am wondering if there is any function that checks the existence of a table? Or, how to list all the tables in a SQLite database using DBI? Thanks a lot!

Re: How to check the existence of a table?

Yu Wang xiaohuwang at hotmail.com writes: I use DBD::SQLite as my database and I am wondering if there is any function that checks the existence of a table? Or, how to list all the tables in a SQLite database using DBI? Thanks a lot! Solved $dbh-tables(undef, undef, 'table_name