On 30 Oct 2006 09:59:46 -0800, in mailing.database.mysql
ja***********@gmail.com
<11**********************@b28g2000cwb.googlegroups .comwrote:
>| Hey lark,
|
| I guess what I'm trying to say, is that I want to know if its possible
| to prevent same name databases.
SHOW DATABASES [LIKE 'pattern']
>| lark wrote:
| the case insensitive directive is in your .cnf or .ini file. change it
| so that it wouldn't matter to the server whether it's upper or lower case.
| >
| ja***********@gmail.com wrote:
| hello,
|
| We are running mysql 4.1.18
|
| Is there a way to prevent users from creating the same database name?
| for example
| our name schema goes like: mysql_1234, mysql_32143, mysql_....
| But we found out that some one could create MYSQL_1234 while mysql_1234
| already exists.
| I guess what we need to know is that if there is away for mysql to not
| allow same names even though its different case characters.
|
| thanks,
| Javier.
|
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
