Re: Retrieving the system type that MySQL is running on.

[Nathan Jones]

The user is to define the database and table names, but may not know the 
system that MySQL is on, and try to request a table or database expecting 
case sensitivity and wind up with case insensitivity.  I want to check the 
existence of the database or table, before trying to create it, rather than 
try to create it and find out it can't be created because it already 
exists.  An alternative (which is actually better) would be a query to 
determine case sensitivity, but I can't figure out how to get that info 
from MySQL either.

At 02:43 AM 11/11/2003, Matt W wrote:
Hi Nathan,

I don't think there's a way if MySQL is on a separate machine, as I'm
only aware of checking in PHP.
Hmm, maybe you could create a dummy table and see if it's case-sensitive
or not? He he.
Just curious, why would you need to know what OS MySQL is on?

Matt

----- Original Message -----
From: "Nathan Jones"
Sent: Monday, November 10, 2003 8:02 PM
Subject: Retrieving the system type that MySQL is running on.
> I'm relatively new to MySQL, and I'm writing a PHP script that doesn't
know
> what kind of system the MySQL database is on.  The script and database
> don't have to be on the same system, so I need a way to determine what
kind
> of system (*nix, Win, etc.) MySQL is running on.  Is there a "fool
proof"
> query to determine this?  If so, what is it?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]