[SVN] r2712 (SQL)

[Brad Miller]

Nevermind.
I was trying to make it too hard.  In mysql 4 you don't need to  
select from the catalog you can just use the show commands as in:

show databases;
show tables;
show columns in foo;


Brad

On Feb 19, 2006, at 6:44 AM, Brad Miller wrote:

>
> On Feb 19, 2006, at 4:04 AM, Allan Odgaard wrote:
>
>> On 19/2/2006, at 0:51, Brad Miller wrote:
>>
>>> [...] Mysql < 5.0 will be more problematic to support since it  
>>> does not support the information_schema view [...]
>>
>> Problematic as in, little code re-use?
>>
>> I have a `mysqlshow` command from MySQL 4 which allows me to query  
>> the database.
>>
> Right,  mysql-4 will require different queries.  I think the mysql  
> driver will work for either 4 or 5.
>
> I haven't spent much time on it but my googling for the tables  
> containing catalog information in mysql keep pointing me to 5.  So  
> if you happen to know the names of the system catalog tables that  
> would help!
>
> Brad
>
>> _______________________________________________
>> textmate-dev mailing list
>> textmate-dev at lists.macromates.com
>> http://lists.macromates.com/mailman/listinfo/textmate-dev
>
> _______________________________________________
> textmate-dev mailing list
> textmate-dev at lists.macromates.com
> http://lists.macromates.com/mailman/listinfo/textmate-dev