Re: Re: A MySQL Question

Nathan Rixham wrote:

tedd wrote:

At 3:24 PM +0000 12/7/08, Nathan Rixham wrote:

On the same not does anybody else frequently use (or even know about) the awesome spatial extension for mysql? or use the information_schema tables?

I've certainly never used them, but I can imagine information_schema tables that are similar to DOCTYPE as found in xml for defining fields -- is that it? Cheers, tedd

not many have :p but there's so much more power and speed can be opened up by using them.. to get you started ( I highly recommend this ) try: SELECT * FROM information_schema.TABLES; then: SELECT * FROM information_schema.COLUMNS

The idea behind information_schema is it should be reasonably portable and should work on most types of db's. -- Postgresql & php tutorials http://www.designmagick.com/