|
Posted by Jeff North on October 30, 2006, 3:30 pm
Please log in for more thread options On 30 Oct 2006 09:59:46 -0800, in mailing.database.mysql
javier.ortega@gmail.com
>| 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.
>| >
>| > javier.ortega@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.
>| > >
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
| 
XML Sitemap